Post reply

moving large data

  • July 17, 2012 at 7:50 pm

    #276062

    I need to move over 30 million rows from server A table A1 to server B table B1.

    Which is the best option to do this? is import/export wizard handle this.

    Is there special things need to take care.

    sERVER A sql version sql 2008 sp2

    server B sql version sql 2008 sp1

  • July 17, 2012 at 8:23 pm

    #1513976

    I routinely move that much data using SSIS, with fast load option without worrying too much... depends on your size per row, it may be faster than you think too

    but then it depends if your table is frequently updated (like in a large OLTP environment)... I deal with DW environment, so I am not too worried about lock / etc (unless it goes way too long)

    i also tried copy data wizard.. and find ssis faster in general..

  • July 17, 2012 at 10:11 pm

    #1513988

    Could you please provide the servers are in production? If these are in production, I would suggest to use the wizard/query if you dont have SSIS at down time.

  • July 19, 2012 at 11:14 am

    #1515027

    import/export wizard is easy to use and certainly fast enough to handle 30M rows.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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