Data Type Mapping

Some of the data types of MSSQL don’t match directly with PostgreSQL data types, so you need to change it to corresponding PostgreSQL data type.

Please check the below table.

Microsoft SQL Server to PostgreSQL Migration

SQLines open source tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server to PostgreSQL:

• • SQLines Data - Data transfer, schema migration and validation tool

  • SQLines SQL Converter - SQL scripts conversion tool

Databases:

• • Microsoft SQL Server 2016, 2014, 2012, 2008, 2005 and 2000

  • PostgreSQL 10.x and 9.x

ORACLE -TO -POSTGRESQL

The following chart lists not able differences between Oracle and PostgreSQL data types.