LAN to DMZ SQL 2000 Replication

cosycosy Posts: 4
HI All,

I got my main sql 2000 Server in LAN and i need to replicate 2 Databases and each got 10-15 tabels and all these tabels got 5-7GB Data.

My Web Server in DMZ and running SQL 2000. I need my main Sql to replicate to this web server in DMZ.

Please tell me what is the best way to do this task?


  • Options

    Can i use SQL Compare or DATA Compare to do above task?
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Cosy,

    It would be possible to use SQL Data Compare to move data into your database in the DMZ. Whether or not it's practical is another question entirely. Data Compare needs to compare all data before synchronizing, which can be a time-consuming process. If you could create views on the database to limit the number or records compared (say, just the rows inserted today) and compare the views instead, it may work better.

    Optionally, you can use SQL Backup's Log Shipping feature to push only the changes in the data and schema without having to compare anything. The drawback is that the database in the DMZ would need to be read-only.

    If none of these works you're best off using SQL Server's built-in publisher/subscriber replication features.
  • Options
    HI Brian,

    With SQL Data Compare, can we schedule this task?

    is this move all the data or only the changes after compare?

    Compare the views? can i see any example to create ?

    I need to replicate few tables so can we use Log Shipping?

    what is the different between MS Replication and SQL data compare?
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Cosy,

    The professional edition of Data Compare allows command-line execution, which you can add to a scheduled task for regular synchronizations. It works by first, comparing all of the data, then generating a SQL script to insert, update, or delete rows of data. If the number of changes is slight, this script will be small. Comparing through a view is the same as comparing a table. If you create the view with a unique index in both databases, the view will be picked up and compared.

    The differences between Data Compare, log shipping and replication are pretty vast, but basically, log shipping and replication don't need to compare data at every synchronization; they simply push out the latest changes to the standby database. At every synchronization, log shipping and replication mark a 'checkpoint' to note where the latest changes begin for the next synchronization.

    The similarities between Data Compare and replication are that you can create vertical and horizontal filters, allowing you to synchronize a subset of tables or even columns and rows within the table. Log Shipping will force all changes without filtering.
Sign In or Register to comment.