If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Yes, db2move should indeed do the job.
Remember to duplicate also any aliases, views, triggers, user-defined functions, ...
I've never used the ixf file format so I'm not sure if it will be loadable by SQLServer. You should maybe first try out the whole chain with a single table to check this.

For a finer control over tables, file format, etc. you can also directly use the export utility (and e.g. use the DEL file format). You could use the list of table names generated by db2move.

Unless I am mistaken, it looks like you only want to move data, not structures.

You can use the db2 export utility to export each table. Do not use the IXF format with MS SQL Server unless you want to be extremely frustrated. It only works with DB2. You'll need to use DEL (delimited), but be careful. Any apostrophies and or commas in you text will ruin the export. You may have to chose a nonsense set of delimiters and text qualifiers. I've tried the pipe "|", the tilde "~", the hat accent or whetever it's called "^", and other ASCII characters that are not commonly used. It's all trial and error.

You can use the syscat.tables view to get a list of tables to export. Use this to build your export statements.