Post reply

Is this replication strategy any Good ? Read on

  • July 3, 2006 at 10:52 am

    #61413

    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)

  • July 4, 2006 at 2:45 am

    #647325

    Hi

    You can try log shipping  and set you logs to execute on a hourly basis

    regards

    wayne

  • July 4, 2006 at 5:04 am

    #647349

    bcp is one way to do it, you could also use bulk insert, or a select into in chunks of 100,000 rows a while loop. I think you will find bcp is fastest.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply