Microsoft SQL Server to Amazon Redshift Migration

SQLines provides tools 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.

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

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	TEXT	⇐ 256
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.