copy tables to the server

• nalrud

  SSC Veteran

  Points: 212

  More actions

  January 21, 2005 at 2:22 pm

  #68038

  Hi All,

  I have a dilemma. I have databases on 2 servers that are linked. One of them is processing server (combines and processes data). The other one is used for cube creation. I need to transfer data from the processing server to the cube creation server. I have written stored procedure to loop through the servers and id tables that have data differences and then run inserts into them. The process is too slow. I know that DTS is much faster, but I do not want to DTS all of the tables in. Is there a way to ID only tables that have row differences and DTS them into Cube creation server (preferably only rows that are missing)?

• Wayne Lawton

  Hall of Fame

  Points: 3532

  More actions

  January 21, 2005 at 2:25 pm

  #538599

  Have you considered replication?  Replication has its own set of challenges, but may work in your situation.

   

  Hope this helps

  Wayne