Is this replication strategy any Good ? Read on

• John Burchel

  Hall of Fame

  Points: 3611

  More actions

  July 3, 2006 at 10:53 am

  #173145

  Replication Strategy

   

   

  Hi All,

   

  Can anyone advice on this replication strategy and whether it is the best way to go about  it:

   

  We have tables created daily with around 8 million records, the way we move those tables around between servers at the moment is to BCP it out, then the receiving server BCP’s in the table.

   

  Are there any performance gains/losses using this method and how can it be improved ? or is there another way to do it, we don’t want to use SQL replication.

   

   

   

  ---

  Kindest Regards,

  John Burchel (Trainee Developer)
  

• Gino-123103

  SSC Enthusiast

  Points: 127

  More actions

  July 4, 2006 at 1:57 pm

  #647386

  if your schema changes often, replication can be tedious.

  8 million records is a lot to keep juggling around with any method but it sounds like bcp is the way to go.

  on second though maybe DTS import tables.

• Dinakar Nethi-176633

  SSCarpal Tunnel

  Points: 4689

  More actions

  July 5, 2006 at 11:18 am

  #647569

  BCP is faster than DTS.

  ******************
  Dinakar Nethi
  Life is short. Enjoy it.
  ******************