Differences

This shows you the differences between two versions of the page.

home [April 06, 2019 10:18 am]
sqlines
home [May 17, 2021 1:05 pm] (current)
sqlines
Line 1: Line 1:
- 
- 
- 
====== Data and Analytics Platform Migration ====== ====== Data and Analytics Platform Migration ======
-SQLines provides services and open source tools to help you migrate databases and applications on-premise and cloud:+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.
-  * Database Migration +  * **SQLines SQL Converter**
-  * ETL and Reporting Migration +
-  * Application Migration+
-====== Open Source Migration Tools ====== +SQLines SQL Converter converts database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers between all major databases.
- +
-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**
-SQLines Data is a scalable, high performance data transfer and schema conversion tool supporting all major databases. [[/sqldata|More...]] +SQLines Data is a scalable, high performance data transfer and schema conversion tool supporting major databases. [[/sqldata|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. +
====== Migration Knowledge Base ====== ====== Migration Knowledge Base ======
Line 30: Line 18:
**Migration to MariaDB** **Migration to MariaDB**
-  * [[/sybase-to-mariadb/convert_datetime_to_string|CONVERT Datetime to String]] - Sybase ASE to MariaDB Migration {{:new.jpg|}} +  * [[/mariadb/row_size_too_large|Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535]] {{:new.jpg|}} 
-  * [[/sybase-to-mariadb/declare_cursor|Moving DECLARE CURSOR statements and variable references in cursors]] - Sybase ASE to MariaDB Migration {{:new.jpg|}} +  * [[/oracle-to-mariadb/connect_by_prior|CONNECT BY PRIOR - Hierarchical Queries]] - Oracle to MariaDB Migration {{:new.jpg|}} 
-  * [[/sybase-to-mariadb/concat|String Concatenation (+) NULL Issues]] - Sybase ASE to MariaDB Migration {{:new.jpg|}}+  * [[/sybase-to-mariadb/convert_datetime_to_string|CONVERT Datetime to String]] - Sybase ASE to MariaDB Migration  
 +  * [[/sybase-to-mariadb/declare_cursor|Moving DECLARE CURSOR statements and variable references in cursors]] - Sybase ASE to MariaDB Migration  
 +  * [[/sybase-to-mariadb/concat|String Concatenation (+) NULL Issues]] - Sybase ASE to MariaDB Migration
  * [[/sybase-to-mariadb/identity|IDENTITY to AUTO_INCREMENT Conversion Issues]] - Sybase ASE to MariaDB Migration   * [[/sybase-to-mariadb/identity|IDENTITY to AUTO_INCREMENT Conversion Issues]] - Sybase ASE to MariaDB Migration
 +
 +
 +**Migration to PostgreSQL**
 +
 +  * [[/db2-to-postgresql/cursor_with_return|DECLARE CURSOR WITH RETURN]] - IBM DB2 to PostgreSQL Migration {{:new.jpg|}}
 +  * [[/oracle-to-postgresql/return_sys_refcursor|Returning SYS_REFCURSOR from Stored Procedure]] - Oracle to PostgreSQL Migration {{:new.jpg|}}
 +  * [[/informix-to-postgresql/interval_second_to_second|INTERVAL SECOND TO SECOND - Get Total Number of Seconds]] - Informix to PostgreSQL Migration
 +  * [[/informix-to-postgresql/grant|GRANT statement]] - Informix to PostgreSQL Migration
 +  * [[/informix-to-postgresql/string_sorting_order|String sorting order]] - Informix to PostgreSQL Migration
 +  * [[/postgresql/how-to//dateadd|How to implement DATEADD function]]
**Migration to Oracle** **Migration to Oracle**
Line 57: Line 57:
  * [[/mysql/duplicate_entry_for_key_error|Duplicate entry for key error]] {{:new.jpg|}}   * [[/mysql/duplicate_entry_for_key_error|Duplicate entry for key error]] {{:new.jpg|}}
  * [[/oracle-to-mysql/trunc_datetime|Truncate Datetime]] - Oracle to MySQL Migration   * [[/oracle-to-mysql/trunc_datetime|Truncate Datetime]] - Oracle to MySQL Migration
- 
-**Migration to PostgreSQL** 
- 
-  * [[/informix-to-postgresql/interval_second_to_second|INTERVAL SECOND TO SECOND - Get Total Number of Seconds]] - Informix to PostgreSQL Migration  
-  * [[/informix-to-postgresql/grant|GRANT statement]] - Informix to PostgreSQL Migration  
-  * [[/informix-to-postgresql/string_sorting_order|String sorting order]] - Informix to PostgreSQL Migration 
-  * [[/postgresql/how-to//dateadd|How to implement DATEADD function]]  
**Oracle** **Oracle**