Convert Online

SQLines SQL Converter

Overview
Command Line
Release Notes

SQLines Data

Overview
Command Line
Configuration File
Connection Strings

Migration to MariaDB

IBM DB2 to MariaDB
Informix to MariaDB
MySQL to MariaDB
Oracle to MariaDB
SQL Server to MariaDB
Sybase ASE to MariaDB
Sybase ASA to MariaDB
PostgreSQL to MariaDB

Migration to SingleStore

SQL Server to SingleStore

Migration to Oracle

IBM DB2 to Oracle
Informix to Oracle
Sybase ASE to Oracle
Sybase ASA to Oracle
SQL Server to Oracle
Teradata to Oracle
PostgreSQL to Oracle
MySQL to Oracle

Oracle PL/SQL to Java
COBOL to Oracle PL/SQL

Migration to SQL Server

IBM DB2 to SQL Server
Informix to SQL Server
MySQL to SQL Server
Netezza to SQL Server
Oracle to SQL Server
PostgreSQL to SQL Server
Sybase ASE to SQL Server
Sybase ASA to SQL Server
Sybase ADS to SQL Server

Migration to MySQL

IBM DB2 to MySQL
Informix to MySQL
Sybase ASE to MySQL
Oracle to MySQL
SQL Server to MySQL
PostgreSQL to MySQL

Migration to PostgreSQL

IBM DB2 to PostgreSQL
Informix to PostgreSQL
Sybase ASE to PostgreSQL
Sybase ASA to PostgreSQL
Oracle to PostgreSQL
SQL Server to PostgreSQL
MySQL to PostgreSQL

Migration to IBM DB2

SQL Server to IBM DB2

Migration to Redshift

Hadoop to Redshift
Netezza to Redshift
Oracle to Redshift
SQL Server to Redshift
Teradata to Redshift

Migration to Snowflake

IBM DB2 to Snowflake
Hadoop to Snowflake
Oracle to Snowflake
SQL Server to Snowflake
Teradata to Snowflake

Migration to Apache Hive

MySQL to Hive
Oracle to Hive
Redshift to Hive
SQL Server to Hive
Teradata to Hive

Migration to Spark

Oracle to Spark
Redshift to Spark
SQL Server to Spark
Teradata to Spark

Migration to Presto/Trino

Hive to Trino
Oracle to Trino
Redshift to Trino
SQL Server to Trino
Teradata to Trino

Migration to Netezza

Oracle to Netezza

Migration to Greenplum

IBM DB2 to Greenplum
Oracle to Greenplum

Migration to EsgynDB

Oracle to EsgynDB
Teradata to EsgynDB

Application Conversion

Java
C# .NET
PowerBuilder
COBOL

Database Reference

Oracle
SQL Server
IBM DB2
MariaDB
MySQL
PostgreSQL
Sybase
Sybase ASA
Informix
Teradata


Microsoft SQL Server to IBM DB2 Migration

SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server (MSSQL, MS SQL), Azure SQL Database, Azure Synapse to IBM DB2:

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

Databases:

  • Microsoft SQL Server 2022, 2019, 2017, 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

CREATE FUNCTION Statement

Converting Transact-SQL user-defined functions:

SQL Server IBM DB2
1 CREATE FUNCTION | ALTER FUNCTION name CREATE OR REPLACE FUNCTION name
2 @param [AS] datatype = default p_param datatype DEFAULT default
3 RETURNS datatype(len) RETURNS datatype(len)
4 Optional AS before the function body Removed
5 Optional statement delimiter ; is added after each statement

For more information, see Conversion of Transact-SQL Statements.

CREATE PROCEDURE Statement

Converting Transact-SQL stored procedures:

SQL Server IBM DB2
1 CREATE PROCEDURE name CREATE OR REPLACE PROCEDURE name
2 @param [AS] datatype = default p_param datatype DEFAULT default
3 Optional AS before the procedure body Removed
4 Optional statement delimiter ; is added after each statement

For more information, see Conversion of Transact-SQL Statements.

Transact-SQL Statements

Variable declaration and assignment:

SQL Server IBM DB2
1 DECLARE @v1 type1, @v2 type2, … DECLARE v1 type1; DECLARE v2 type2, DECLARE …