SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server to IBM DB2:
Databases:
Converting data types:
SQL Server | IBM DB2 | |
CHAR | Fixed-length character string | CHAR |
INT, INTEGER | 32-bit integer | INT, INTEGER |
SMALLINT | 16-bit integer | SMALLINT |
VARCHAR | Variable-length character string | VARCHAR |