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.

SQL Server to Redshift Migration Tools

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

SQLines SQL Converter 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.

SQL Server to Redshift Migration Reference

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

Data Types

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 TEXT ⇐ 256
34 XML XML data, ⇐ 2G -

CREATE TABLE Statement

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

SQL Server Redshift
1 IDENTITY(start, increment) Identity column IDENTITY(start, increment)
2 CONSTRAINT name PRIMARY | UNIQUE … Constraint name PRIMARY | UNIQUE …
3 PRIMARY KEY CLUSTERED Primary key Constraint PRIMARY KEY
4 CHECK bool_expr CHECK Constraint Not supported by Redshift, commented

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