Dear all,

I want to dump data from DB2 database to Sqlserver ,

could any one suggest me for

Using Linked Server or OpenRowSet command.

Read the following articles, it may be useful,

http://www.mssqltips.com/sqlservertip/2151/how-to-create-a-sql-server-link-server-to-ibm-db2/
http://stackoverflow.com/questions/10761747/t-sql-openrowset-copying-tables-between-databases-on-the-same-server
http://support.microsoft.com/kb/277716

Hello,

Create a linked server using an ODBC DSN created with the IBM Client Access driver.

I have not been able to retrieve data from DB2 tables with indexes, so my suggestion is to create tables on DB2 with no indexes where you can put the data you would like to export from DB2, and then use the linked server to import the data to SQL Server from those tables. SQL Server Integration Services may help you automate the process.

If at some point you are interested on writing information back from SQL Server to DB2, you may have implement journaling on the IBM computer (AS/400 for example).

Hope this helps.

 
Regards,
Alberto Morillo
SQLCoffee.com

You can try the following software http://dbconvert.com/convert-mssql-to-db2-pro.php to automate your migration tasks.

Hi Hari,

I've gone thru this for our BI project and my suggestions are :-

1) Use IBM OLE DB drivers instead of Microsoft DB2 drivers. Reason being Microsoft drivers require more permissions than just read on the DB2 side. Use 64 bit drivers if possible.

2) Once drivers are installed, you can use a simple tool like SQL mgmt studio import/export wizard.

Thong

Hari,

Have a look at SQLines Data tool (http://www.sqlines.com/db2-to-sql-server). It can migrate and validate data in multiple concurrent sessions. Also there are tools including Online tool for DDL conversion.

Thanks, 

Dmitry