SQLines tools can 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. More...

• 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

• GOTO statement to LEAVE statement with a labeled BEGIN-END block - Oracle 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

• Datetime arithmetic expressions with + and - operators i.e. SYSDATE + 1/24 - Oracle to PostgreSQL
• DATEDIFF function conversion to EXTRACT and INTERVAL expressions - SQL Server to PostgreSQL
• SELECT FOR XML PATH - SQL Server to PostgreSQL
• Zero character code in CHAR or VARCHAR - Oracle to PostgreSQL
• Querying XML Data - SQL Server to PostgreSQL
• JSON_TABLE Function - Oracle to PostgreSQL
• PIVOT Clause in SELECT Statement - SQL Server to PostgreSQL
• CREATE TRIGGER Statement - Oracle to PostgreSQL
• PIPELINED Functions - Oracle to PostgreSQL
• INSTR function conversion - Oracle to PostgreSQL
• DECLARE CURSOR WITH RETURN - IBM DB2 to PostgreSQL
• Returning SYS_REFCURSOR from Stored Procedure - Oracle to PostgreSQL
• INTERVAL SECOND TO SECOND - Get Total Number of Seconds - Informix to PostgreSQL
• GRANT statement - Informix to PostgreSQL
• String sorting order - Informix to PostgreSQL
• How to implement DATEADD function

Migration to Oracle

• Processing Result Sets in a SQL Procedure - IBM DB2 to Oracle
• WITH HOLD Cursors - IBM DB2 to Oracle
• Execute OS Command from Procedure - Informix to Oracle
• Temporary Tables - Informix to Oracle
• 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 to Microsoft SQL Server

• Maximum allowable table row size of 8060 bytes - Informix to SQL Server
• Tables exceeding the maximum of 1024 columns - Informix to SQL Server
• XMLELEMENT Function - Oracle to SQL Server
• TRANSLATE Function - IBM DB2 to SQL Server
• INSTR Function - Oracle to SQL Server
• PL/SQL Tables - TYPE name IS TABLE OF - Oracle to SQL Server
• DATETIME or DATETIME2(3)?
• Year 1753 Issues when Migrating Oracle DATE - Oracle to SQL Server
• CHAR Function for Datetime - IBM DB2 to SQL Server
• Datetime Interval Expressions - IBM DB2 to SQL Server
• Constraint Names - Sybase SQL Anywhere to SQL Server

Migration to MySQL

• Converting inserted system table reference in CREATE TRIGGER - SQL Server to MySQL
• Converting table-valued functions (RETURNS TABLE) - SQL Server to MySQL
• SELECT FOR JSON PATH - SQL Server to MySQL
• CREATE TRIGGER Statement - Oracle to MySQL
• Duplicate entry for key error
• Truncate Datetime - Oracle to MySQL

Migration to Snowflake

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

Oracle PL/SQL to Java Migration

• TYPE name IS RECORD

Oracle

• Convert Object Types and Collections to JSON

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