Microsoft SQL Server to IBM DB2 Migration

SQLines open source 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:

  • SQLines Data - Data transfer, schema migration and validation tool
  • SQLines SQL Converter - SQL scripts conversion tool

Databases:

  • Microsoft SQL Server 2016, 2014, 2012, 2008, 2005 and 2000
  • IBM DB2 for LUW, z/OS and OS/400 11.x, 10.x, 9.x, 8.x and 7.x

Migration Reference

Data Types

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