DTS Replication

[melbert2002]

Hello all,
I have a question for everyone. I have just started using SQL server 2000. I have an assignment to replicate one database to another server (running SQL 2000)in almost real time. Now we can not touch the original server (SQL1) like registering the server so that I can turn that server into a publisher and the other server (SQL2) into a subscriber. I have tryed using DTS and it seems to want to do what I want in a round about way, but I would like just the updates to the DB and not to pull the whole DB again. I have tried appending, but that just adds records and does not delete records that have been removed. Is there a way to do this????

Thanks in advance

Melbert

 

[nigelrivett]

Have a look at log shipping.
You can copy log backups if they are being saved and apply them to the destination server.
It has a few limitations on the destination though.


If the source has timestamp columns then you could use that to transfer updates.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[melbert2002]

Thanks for the info.

So if I got this right....What I should do is copy the original DB, then impliment the log shipping? I have not looked at it yet, but can I set it so that the transactions are copied every 10th transaction? Also does Log shipping move the whole log or just x number of transactions?

Thanks again..

Mel Abert

 

[nigelrivett]

You back up the log file on the source then apply it to the destination. You get whatever is in the log file that you back up.

You can only get a read only copy on the dest and it won't be accessible while you are applying the log.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[melbert2002]

Thanks, but that method is just not going to work for me. I will be doing updates on a regular basis and can not afford to have much downtime. What about doing a DTS replication by just copying everything every 30 minutes or so. I realize that it may not be the cleanest way of doing what I need but would it work?

Thanks
mel