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. :(