tourcd
IS-IT--Management
- Dec 5, 2005
- 37
Hi,
I've got the following problem and not sure where to start with it.
I've got a database on ServerA with a table called Customers. I want to copy this table to ServerB, I cannot use replication. I want to schedule a copy twice a day.
I created a DTS package that copies the table, fine. However it copies the whole lot, all 500K records. I don't have the bandwidth for this so need a solution that only copies updated and new records.
Looking around I thought implementing SQL Server Log Shipping might help but if a failure occurs it requires manual intervention to get the target server up and running, this is no good.
Does anyone have suggestions on how I might solve my problem?
Is going down the DTS route the right thing to do?
Thanks
I've got the following problem and not sure where to start with it.
I've got a database on ServerA with a table called Customers. I want to copy this table to ServerB, I cannot use replication. I want to schedule a copy twice a day.
I created a DTS package that copies the table, fine. However it copies the whole lot, all 500K records. I don't have the bandwidth for this so need a solution that only copies updated and new records.
Looking around I thought implementing SQL Server Log Shipping might help but if a failure occurs it requires manual intervention to get the target server up and running, this is no good.
Does anyone have suggestions on how I might solve my problem?
Is going down the DTS route the right thing to do?
Thanks