Convert Online

SQLines Data

Overview
Command Line
Configuration File
Connection Strings
Data Validation

SQLines SQL Converter

Overview
Command Line
Configuration File

Migration to MariaDB

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

Migration to MySQL

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

Migration to PostgreSQL

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

Migration to SQL Server

IBM DB2 to SQL Server
Informix to SQL Server
MySQL 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 Oracle

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

SQL in Applications

Java


IBM DB2 to Snowflake Migration

SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from IBM DB2 to Snowflake.

  • SQLines SQL Converter - SQL scripts assessment and conversion tool

Databases:

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

Migration Reference

Built-in SQL Functions

Converting functions:

DB2 Snowflake
1 CURRENT DATE Get the current date CURRENT_DATE
CURRENT_DATE

CREATE SEQUENCE

Converting CREATE SEQUENCE statements:

DB2 Snowflake
1 CREATE [OR REPLACE] SEQUENCE seq_name CREATE [OR REPLACE] SEQUENCE seq_name
2 INCREMENT BY num Positive or negative increment, default is 1 INCREMENT BY num
3 START WITH num Initial value START WITH num
4 MAXVALUE num Maximum value is num Removed
NO MAXVALUE System limit Removed
5 MINVALUE num Minimum value is num Removed
NO MINVALUE System limit Removed
6 CYCLE Reuse values after reaching the limit Removed
NO CYCLE No reuse, this is default Removed
7 CACHE num Cache num values Removed
NO CACHE Values are not preallocated Removed
8 ORDER Guarantee numbers in order of requests ORDER
NO ORDER No guarantee, this is default NOORDER

SQL Statements

Converting SQL statements:

DB2 Snowflake
1 CONNECT TO dbname Connect to the database Commented
2 CREATE SCHEMA schema Create a schema CREATE SCHEMA schema