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

• Database Migration
• ETL and Reporting Migration
• Application Migration

SQLines develops tools to transfer data, convert database schema (DDL), views, stored procedures, packages, user-defined functions, triggers, queries, SQL scripts, embedded SQL and database API between databases.

• SQLines SQL Converter

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

• SQLines Data

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

Recent articles:

Migration to MariaDB

• CONNECT BY PRIOR - Hierarchical Queries - Oracle to MariaDB Migration
• 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 PostgreSQL

• Returning SYS_REFCURSOR from Stored Procedure - Oracle to PostgreSQL Migration
• 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

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

Oracle

• Convert Object Types and Collections to JSON

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