Microsoft SQL Server to Amazon Redshift Migration

SQLines provides open source tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server to Amazon Redshift.

We also help convert embedded SQL statements in C/C++ (ODBC, ESQL/C, DBLIB), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Python, Perl/PHP and other applications.

• Microsoft SQL Server 2016, 2014, 2012, 2008, 2005 and 2000
• Amazon Redshift

SQLines tools to help you migrate from Microsoft SQL Server to Amazon Redshift:

• SQLines SQL Conversion Tool
• SQLines Data - Data Transfer, Schema Migration and Validation Tool
• Online SQL Conversion Tool

SQLines SQL Converter tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from Microsoft SQL Server to Redshift.

SQLines tool converts SQL scripts and standalone SQL statements. To migrate data and database schema from an SQL Server database use SQLines Data tool.

Try SQLines Online or download the Desktop Version.

Technical information on migration from Microsoft SQL Server to Amazon Redshift.

• Data Types
• CREATE TABLE

Converting data types from SQL Server to Amazon Redshift:

	SQL Server		Redshift
1	BIGINT	64-bit integer	BIGINT
2	BINARY(n)	Fixed-length byte string, 1 ⇐ n ⇐ 8000	-
3	BIT	1, 0 or NULL	SMALLINT
4	CHAR(n)	Fixed-length string, 1 ⇐ n ⇐ 8000	CHAR(n)
5	DATE	Date (year, month and day)	DATE
6	DATETIME	Date and time with fraction	TIMESTAMP
7	DATETIME2(p)	Date and time with fraction	TIMESTAMP
8	DATETIMEOFFSET(p)	Date and time with fraction and time zone	TIMESTAMPTZ
9	DECIMAL(p,s)	Fixed-point number	DECIMAL(p,s)
10	DOUBLE PRECISION	Double-precision floating-point number	DOUBLE PRECISION
11	FLOAT(p)	Floating-point number	FLOAT
12	IMAGE	Variable-length binary data, ⇐ 2G	-
13	INT, INTEGER	32-bit integer	INT, INTEGER
14	MONEY	64-bit currency amount	DECIMAL(15,4)
15	NCHAR(n)	Fixed-length Unicode UCS-2 string, 1 ⇐ n ⇐ 4000	-
16	NTEXT	Variable-length Unicode UCS-2 data, ⇐ 2G	LONGTEXT
17	NUMERIC(p,s)	Fixed-point number	NUMERIC(p,s)
18	NVARCHAR(n)	Variable-length Unicode UCS-2 string, 1 ⇐ n ⇐ 4000	-
19	NVARCHAR(max)	Variable-length Unicode UCS-2 data, ⇐ 2G	-
20	REAL	Single-precision floating-point number	REAL
21	ROWVERSION	Automatically updated binary data	-
22	SMALLDATETIME	Datetime (year, month, day, hour, minutes and 00 seconds )	TIMESTAMP
23	SMALLINT	16-bit integer	SMALLINT
24	SMALLMONEY	32-bit currency amount	DECIMAL(6,4)
25	TEXT	Variable-length character data, ⇐ 2G	-
26	TIME(p)	Time (Hour, minute, second and fraction)	-
27	TIMESTAMP	Automatically updated binary data	-
28	TINYINT	8-bit unsigned integer, 0 to 255	SMALLINT
29	UNIQUEIDENTIFIER	16-byte GUID (UUID) data	CHAR(16)
30	VARBINARY(n)	Variable-length byte string, 1 ⇐ n ⇐ 8000	-
31	VARBINARY(max)	Variable-length binary data, ⇐ 2G	-
32	VARCHAR(n)	Variable-length character string, 1 ⇐ n ⇐ 8000	VARCHAR(n)
33	VARCHAR(max)	Variable-length character data, ⇐ 2G	-
34	XML	XML data, ⇐ 2G	-

Converting CREATE TABLE statement keywords and clauses from SQL Server to Amazon Redshift:

Primary, unique and foreign key constraints are informational only in Amazon Redshift.