IBM DB2 to MariaDB Migration

SQLines provides services and tools to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from IBM DB2 to MariaDB.

We also help convert embedded SQL statements in C/C++ (ODBC, ESQL/C), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl, PHP, Python, Linux shell and other applications.

SQLines can also assist you to convert COBOL stored procedures and programs to MariaDB procedural language or Java.

Databases:

• IBM DB2 for LUW, z/OS and OS/400 11.x, 10.x, 9.x, 8.x and 7.x
• MariaDB 10.x

SQLines tools to help you migrate from IBM DB2 to MariaDB:

• SQLines Data - Data Transfer, Schema Migration and Validation Tool
• SQLines SQL Converter - SQL Scripts Conversion Tool
• Online SQL Conversion Tool

• Data Types

Character data types:

	DB2		MariaDB
1	VARCHAR(n OCTETS)	Variable-length string in bytes, 1 ⇐ n ⇐ 32672	VARCHAR(n)	n ⇐ 65535, n in characters

Binary data types:

Numeric data types:

Data and time data types:

	DB2		MariaDB
1	TIMESTAMP(p)	Date and time with fraction, 0 ⇐ p ⇐ 12 , default 6	DATETIME(p)	p ⇐ 6

Large objects data types: