March 2, 2006 at 5:05 am
Hello all,
I need to copy data from one SQL Server 2000 server to another at different geographic locations. I have to be able to copy on an "as need basis". Some of the tables have a few thousand records.
I was using Copy SQL Server Objects task. The problem is there is a lag time when the data displays. It can be a few minutes which of course is unacceptable to the clients.
I thought of 2 ways.
One is snapshot replication. But again I have to do this on an as need basis. I can't schedule the replication because I don't want to have it run before the data is cleansed properly.
Two is copying the tables up with a new name, rename the tables and drop the old.
Anyone with any other ideas?
March 2, 2006 at 9:06 am
Is your Copy SQL Server Objects task dropping and recreating the destination tables or deleting data in the destination tables and then copying data? If so, it would be faster to truncate the destination tables with an Execute SQL task then copy data with a Transform Data task.
Greg
Greg
March 2, 2006 at 9:57 pm
I want to know how often u need to copy the tables data from source to destination.
Then the position will be clear.
from
Killer
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply