How to convert PostgreSQL to SQL Server

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 SQL Server compared to the source PostgreSQL. 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:

• array varchar(max)
• boolean bit
• bytea varbinary(max)
• char varchar(max) (if precision > 8000)
• cidr varchar(50)
• citext varchar(max)
• double precision float(53)
• enum varchar(255)
• hstore varchar(max)
• inet varchar(50)
• interval int
• json nvarchar(max)
• jsonb nvarchar(max)
• macaddr varchar(50)
• money decimal(19,2)
• oid varbinary(max)
• real float
• text varchar(max)
• timestamp datetime2 (if version at least 10)
• timestamp datetime (if version earlier than 10)
• timestamptz datetimeoffset
• uuid uniqueidentifier
• varbit varbinary
• varchar varchar(max) (if precision > 8000)