SQLines provides tools to help you transfer data, convert database schema (DDL), views, stored procedures, packages, user-defined functions (UDFs), triggers, SQL queries, SQL scripts between different database platforms.

• 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 high performance tool that uses native database clients and can help you automate data transfer and schema conversion for major enterprise databases. More...

Recent articles:

Migration to MariaDB

• STUFF and SELECT FOR XML PATH - SQL Server to MariaDB Migration
• INITCAP user-defined function - Oracle to MariaDB Migration
• MONTHS_BETWEEN function conversion - Oracle to MariaDB Migration
• TRANSLATE function conversion - Oracle to MariaDB Migration
• INSTR function conversion - Oracle to MariaDB Migration
• Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535
• 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

• JSON_TABLE Function - Oracle to PostgreSQL Migration
• PIVOT Clause in SELECT Statement - SQL Server to PostgreSQL Migration
• CREATE TRIGGER Statement - Oracle to PostgreSQL Migration
• PIPELINED Functions - Oracle to PostgreSQL Migration
• INSTR function conversion - Oracle to PostgreSQL Migration
• DECLARE CURSOR WITH RETURN - IBM DB2 to PostgreSQL Migration
• 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

• XMLELEMENT Function - Oracle to SQL Server Migration
• TRANSLATE Function - IBM DB2 to SQL Server Migration
• INSTR Function - Oracle to SQL Server Migration
• PL/SQL Tables - TYPE name IS TABLE OF - Oracle to SQL Server Migration
• 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

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

Migration to Snowflake

• SYSDATE + 1/24 - Datetime Arithmetic - Oracle to Snowflake Migration

Oracle

• Convert Object Types and Collections to JSON

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