Convert SQL Server Express to Amazon Redshift

Making migration easy for you

Full Convert is a fully self-tuning software. Your migration will work as expected without you needing to adjust anything.

Data types are different in Amazon Redshift compared to SQL Server Express. We automatically adjust them as we copy the tables so you don't have to worry about it. You can adjust the mapping rules if you wish to change the following defaults:

• binary varchar(max)
• bit boolean
• char varchar(65535) (if precision > 65535)
• char varchar (if precision > 4096 and precision <= 65535)
• datetime timestamp
• datetime2 timestamp
• datetimeoffset timestamptz
• double double precision
• float real
• geography geometry (if spatial_supported is true)
• hierarchyid varchar(255)
• image varchar(max)
• int integer
• money decimal(19,4)
• nchar varchar(65535) (if precision > 65535)
• nchar varchar (if precision > 4096 and precision <= 65535)
• nchar char (if precision <= 4096)
• ntext varchar(max)
• nvarchar varchar(65535) (if precision > 65535)
• nvarchar varchar (if precision <= 65535)
• nvarchar(max) varchar(max)
• smalldatetime timestamp
• smallmoney decimal(19,4)
• text varchar(max)
• timestamp varchar(max)
• tinyint smallint
• uniqueidentifier varchar(36)
• varbinary varchar(max)
• varbinary(max) varchar(max)
• xml varchar(max)