October 5, 2007 at 6:54 am
I am trying to move some table from one Sql server to a data repository on a daily basis and would like to some idea what method to use and how to use it
October 5, 2007 at 7:03 am
Replication? DTS? There's a couple of options for you, but we'll need a bit more information before being able to provide any solid advice.
John
October 5, 2007 at 7:08 am
Here is the situation. What I am trying to do is that since we are using the Data repository for reporting purposes and accessed by various reporting tools I want to transfer about 5 tables from a different sql server that has information required for some reports.
October 5, 2007 at 7:31 am
Still need more information. The tables that you want to copy - are they cleared down and repopulated every day? Or do they have new rows added every day? Or are existing rows updated? Do the tables have primary key constraints? Is there any way of knowing when/whether a row has been added or updated?
If you've just got rows being added at the "end" of your table, then it's probably easiest to use a DTS or a T-SQL job. If it's any more complicated than that then replication is likely to be the best solution - although this requires that each table have a primary key.
John
October 10, 2007 at 7:34 pm
I want to replicate or transfer a few columns from the table in the DR and I can over write them every night
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply