SQLines provides open source tools to help you migrate databases and applications on-premise and cloud:

• Database Migration
• ETL and Reporting Migration
• Application Migration

SQLines offers open source tools to help you transfer data, convert database schema (DDL), views, stored procedures, packages, functions, triggers, queries, SQL scripts, embedded SQL and database API between databases.

• SQLines Data

SQLines Data is a scalable, high performance data transfer and schema conversion tool supporting all major databases. More...

• SQLines SQL Converter

SQLines SQL Converter allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers between all major databases.

Recent articles:

Migration to MariaDB

• CONVERT Datetime to String - Sybase ASE to MariaDB Migration
• Moving DECLARE CURSOR statements and variable references in cursors - Sybase ASE to MariaDB Migration
• String Concatenation (+) NULL Issues - Sybase ASE to MariaDB Migration
• IDENTITY to AUTO_INCREMENT Conversion Issues - Sybase ASE to MariaDB Migration

Migration to Oracle

• Processing Result Sets in a SQL Procedure - IBM DB2 to Oracle Migration
• WITH HOLD Cursors - IBM DB2 to Oracle Migration
• Execute OS Command from Procedure - Informix to Oracle Migration
• Temporary Tables - Informix to Oracle Migration
• Migrating Informix Procedures with RETURN WITH RESUME to Oracle
• Migrate SERIAL Columns from Informix to Oracle
• Export to CSV file from Procedure - PostgreSQL to Oracle Migration

Migration to Microsoft SQL Server

• DATETIME or DATETIME2(3)?
• Year 1753 Issues when Migrating Oracle DATE - Oracle to SQL Server Migration
• CHAR Function for Datetime - IBM DB2 to SQL Server Migration
• Datetime Interval Expressions - IBM DB2 to SQL Server Migration
• Constraint Names - Sybase SQL Anywhere to SQL Server

Migration to MySQL

• Duplicate entry for key error
• Truncate Datetime - Oracle to MySQL Migration

Migration to PostgreSQL

• INTERVAL SECOND TO SECOND - Get Total Number of Seconds - Informix to PostgreSQL Migration
• GRANT statement - Informix to PostgreSQL Migration
• String sorting order - Informix to PostgreSQL Migration
• How to implement DATEADD function

Oracle

• Convert Object Types and Collections to JSON

For more articles, choose a migration direction on the right pane.