Differences

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

informix-to-sql-server [April 14, 2017 2:42 pm]
sqlines
informix-to-sql-server [March 22, 2021 10:28 pm] (current)
sqlines
Line 1: Line 1:
====== Informix to SQL Server Migration ====== ====== Informix to SQL Server Migration ======
-SQLines provides open source tools to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Informix to Microsoft SQL Server+SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Informix to Microsoft SQL Server (MSSQL, SQL Azure).
- +
-We also help convert embedded SQL statements in C/C++, C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Python, Perl/PHP and other applications.+
  * **Informix** 12.x, 11.x, 10.x, 9.x and 7.x (Dynamic Server  IDS and Extended Parallel Server XPS)   * **Informix** 12.x, 11.x, 10.x, 9.x and 7.x (Dynamic Server  IDS and Extended Parallel Server XPS)
-  * **Microsoft SQL Server** 2016, 2014, 2012, 2008 and 2005+  * **Microsoft SQL Server** 2019, 2017, 2016, 2014, 2012, 2008 and 2005
===== Informix to SQL Server Migration Tools ===== ===== Informix to SQL Server Migration Tools =====
Line 50: Line 48:
===== Data Types ===== ===== Data Types =====
-Converting data types:+Character data types: 
 + 
 +| | **Informix** || **SQL Server** || 
 +| 1 | CHAR(//n//), CHARACTER(//n//) | Fixed-length string, 1 %%<=%% //n// %%<=%% 32767 {{:exclamation.png|}} | CHAR(//n//), CHARACTER(//n//) | n %%<=%% 8000 | 
 +|:::|:::|:::| VARCHAR(max) | //n// > 8000 | 
 +| 2 | CHARACTER VARYING(//n,r//) | Variable-length string, 1 %%<=%% //n// %%<=%% 255 | CHARACTER VARYING(//n//) || 
 +| 3 | LVARCHAR(//n//) | Variable-length string, 1%% <=%% //n// %%<=%% 32739 {{:exclamation.png|}} | VARCHAR(//n//) || 
 +| 4 | NCHAR(//n//) | Fixed-length string, 1 %%<=%% //n// %%<=%% 32767 {{:exclamation.png|}} | NCHAR(//n//) || 
 +| 5 | NVARCHAR(//n,r//) | Variable-length string, 1 %%<=%% //n// %%<=%% 255 | NVARCHAR(//n//) || 
 +| 6 | VARCHAR(//n,r//) | Variable-length string, 1 %%<=%% //n// %%<=%% 255 | VARCHAR(//n//) || 
 + 
 +Other data types:
| | **Informix** || **SQL Server** | | | **Informix** || **SQL Server** |
Line 58: Line 67:
| 4 | BOOLEAN | True, false or NULL | BIT | | 4 | BOOLEAN | True, false or NULL | BIT |
| 5 | BYTE | Binary data, <= 2G | VARBINARY(max) | | 5 | BYTE | Binary data, <= 2G | VARBINARY(max) |
-| 6 | CHAR(//n//), CHARACTER(//n//) | Fixed-length string, 1 <= //n// <= 32767 {{:exclamation.png|}} | CHAR(//n//), CHARACTER(//n//) | +| 6 | CLOB | Character large object, <= 4T {{:exclamation.png|}} | VARCHAR(max) | 
-| 7 | CHARACTER VARYING(//n,r//) | Variable-length string, 1 <= //n// <= 255 | CHARACTER VARYING(//n//) | +| 7 | DATE | Date (year, month and day) | DATE | 
-| 8 | CLOB | Character large object, <= 4T {{:exclamation.png|}} | VARCHAR(max) | +| 8 | DATETIME //unit// TO //unit2// | Date and time with fraction | DATETIME2 | 
-| 9 | DATE | Date (year, month and day) | DATE | +| 9 | DECIMAL(//p,s//), DEC(//p,s//) | Fixed-point number | DECIMAL(//p,s//), DEC(//p,s//) | 
-| 10 | DATETIME //unit// TO //unit2// | Date and time with fraction | DATETIME2 | +| 10 | DOUBLE PRECISION | Double-precision floating-point number | FLOAT | 
-| 11 | DECIMAL(//p,s//), DEC(//p,s//) | Fixed-point number | DECIMAL(//p,s//), DEC(//p,s//) | +| 11 | FLOAT(//p//) | Double-precision floating-point number | FLOAT | 
-| 12 | DOUBLE PRECISION | Double-precision floating-point number | FLOAT | +| 12 | INTEGER, INT | 32-bit integer | INTEGER, INT | 
-| 13 | FLOAT(//p//) | Double-precision floating-point number | FLOAT | +| 13 | INT8 | 64-bit integer | BIGINT | 
-| 14 | INTEGER, INT | 32-bit integer | INTEGER, INT | +| 14 | INTERVAL //unit// TO //unit2// | Date and time interval | VARCHAR(30) | 
-| 15 | INT8 | 64-bit integer | BIGINT | +| 15 | MONEY(//p,s//) | Currency amount | MONEY {{:exclamation.png|}} | 
-| 16 | INTERVAL //unit// TO //unit2// | Date and time interval | VARCHAR(30) | +| 16 | NUMERIC(//p,s//) | Fixed-point number | NUMERIC(//p,s//) | 
-| 17 | LVARCHAR(//n//) | Variable-length string, 1 <= //n// <= 32739 {{:exclamation.png|}} | VARCHAR(//n//) | +| 17 | REAL | Single-precision floating-point number | REAL | 
-| 18 | MONEY(//p,s//) | Currency amount | MONEY {{:exclamation.png|}} | +| 18 | SMALLFLOAT | Single-precision floating-point number | REAL | 
-| 19 | NCHAR(//n//) | Fixed-length string, 1 <= //n// <= 32767 {{:exclamation.png|}} | NCHAR(//n//) | +| 19 | SMALLINT | 16-bit integer | SMALLINT | 
-| 20 | NUMERIC(//p,s//) | Fixed-point number | NUMERIC(//p,s//) | +| 20 | SERIAL(//s//) | Auto-increment 32-bit integer | INT {{:exclamation.png|}} | 
-| 21 | NVARCHAR(//n,r//) | Variable-length string, 1 <= //n// <= 255 | NVARCHAR(//n//) | +| 21 | SERIAL8(//s//) | Auto-increment 64-bit integer | BIGINT {{:exclamation.png|}} | 
-| 22 | REAL | Single-precision floating-point number | REAL | +| 22 | TEXT | Character data, <= 2G | VARCHAR(max) |
-| 23 | SMALLFLOAT | Single-precision floating-point number | REAL | +
-| 24 | SMALLINT | 16-bit integer | SMALLINT | +
-| 25 | SERIAL(//s//) | Auto-increment 32-bit integer | INT {{:exclamation.png|}} | +
-| 26 | SERIAL8(//s//) | Auto-increment 64-bit integer | BIGINT {{:exclamation.png|}} | +
-| 27 | TEXT | Character data, <= 2G | VARCHAR(max) | +
-| 28 | VARCHAR(//n,r//) | Variable-length string, 1 <= //n// <= 255 | VARCHAR(//n//) |+
-Data type attributes and options+Data type attributes and options:
| | **Informix** | **SQL Server** | | | **Informix** | **SQL Server** |
-| 1 | //column// BYTE IN TABLE | //column// VARBIANRY(max) | +| 1 | //column// BYTE IN TABLE | //column// VARBINARY(max) | 
-| 2 | //column// BYTE IN //lob_space// | //column// VARBIANRY(max) |+| 2 | //column// BYTE IN //lob_space// | //column// VARBINARY(max) |
| 3 | //column// TEXT IN TABLE | //column// VARCHAR(max) | | 3 | //column// TEXT IN TABLE | //column// VARCHAR(max) |
| 4 | //column// TEXT IN //lob_space// | //column// VARCHAR(max) | | 4 | //column// TEXT IN //lob_space// | //column// VARCHAR(max) |