Post reply

Copy tables to another server

  • August 21, 2008 at 9:11 am

    #130777

    I need to copy some large tables 20 GIG of data approx 10 tables to a new server nightly.

    What be best method.

    BCP or a insert into ....

    Thanks

  • August 21, 2008 at 11:43 am

    #861460

    20GB is a decent chunk of data, any way to identify data that changed over the past 24 hours and just send that? How about using replication?

    Otherwise you could use SSIS to dump all of the data from point A to point B and schedule every night. Not sure what your performance would be, but there could be a big impact on anyone using the data.

    Hth

    Rob

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

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