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.
SQLines tools to help you migrate from Microsoft SQL Server to Amazon Redshift:
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.
Converting data types from SQL Server to Amazon Redshift:
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.