October 4, 2011 at 3:18 pm
How do I copy multiple tables from one server to another using BCP? How should I do error handling in BCP(say if an error occurs in a batch, it should restart from the same batch)?
October 5, 2011 at 4:05 am
I don't think BCP is the right tool for this task.
Have you considered using SSIS?
-- Gianluca Sartori
October 5, 2011 at 5:49 am
Can i use SSIS if I need to migrate from SQL 2000 to SQL 2005?
I thought only DTS is the solution for this because the source database is on SQL 2000.
If this is possible using SSIS, can someone provide me an example package, please?
October 5, 2011 at 6:25 am
You can do it with the wizard, there's no need for an example.
Open SSMS and connect the target database (SQL 2005), right click the database name, select tasks --> import data from the context menu.
This will start the import/export wizard.
Select the tables you want to export and map them to an existing/new table.
Done.
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply