July 17, 2012 at 7:50 pm
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
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
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
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