Transact SQL - Information Schema

Is there a way to query an Information Schema from DB2 and dump the contents(tables - structure only),into another database? I'm looking for a way to cr开发者_StackOverfloweate a shell model of a database schema from DB2 into a SQL Server database?

Thanks

You can use db2look to get the table structure (DDL) out of db2.

Once you've got it, however, I'm afraid you'll have to manually replace any db2-specific syntax (datatypes, storage parameters, etc.) with it's corresponding SQL Server syntax.

It doesn't look like Microsoft's Migration Tool works for db2 yet. :(