Take the 2-minute tour ×

I have a few tables under a sql server database, most of the contents are INT or VARCHAR, two tables have image column. Now i wanted to copy these tables to DB2 10.1 LUW and zseries, and v7r1 on iseries, what is the best way to perform this data migration?


share|improve this question
add comment

2 Answers

Use the Sql Server Integration Services(SSIS) to handle it more efficiently. http://www.packtpub.com/article/mysql-data-transfer-using-sql-server-integration-services-ssis


You can also use the BCP command

share|improve this answer
add comment

SQL Server Import and Export Wizard might help

sql server i&e wizard

share|improve this answer
add comment

Your Answer


