CODEWITHSUNDEEP
sqlsql-serverimportdb2
user256173
user256173

Reputation: 69

How to import DB2 database to Sql server

I'm pretty new to SQL and on collage we used IMB DB2 running on Linux. So i have this

instruction set to import database to DB2. I started using SQL server now, so i wonder is there a way to use this setup to import database to SQL server. There are some syntax differences and .ixf files that i don't know how to use.

Upvotes: 1

Views: 1472

Answers (1)

Lennart - Slava Ukraini
Lennart - Slava Ukraini

Reputation: 7181

You can't export to ixf (because that's a format that only DB2 understands). What you need to do (if using export/import anyhow) is to export to a text format:

db2 "export to mytable.csv of del select * from mytable"

If you need another separator (say ;) you can specify that by:

db2 "export to mytable.csv of del modified by coldel; select * from mytable"

Then you probably have to convert the file to windows format:

#> unix2dos mytable.csv

Move the file to your windows server and use an import utility (bcp?) to import the data.

Upvotes: 1

Related Questions