Home > Documentation > PostgreSQL to MS SQL

PostgreSQL to SQL Server Types Mapping

[Postgres to MS SQL Converter]  [About Migration]  [FAQ

Although PostgreSQL and SQL Server have similar data types, those sets are not absolutly equal. When migrating from PostgreSQL to Microsoft SQL it is necessary to map data types accordng to the table below:

PostgreSQL SQL Server
BIGINT BIGINT
BIGSERIAL BIGINT IDENTITY
BOOLEAN BIT
BYTEA VARBINARY(max)
CHAR(n), CHARACTER(n) CHAR(n), CHARACTER(n)
DATE DATE
DECIMAL(p,s), DEC(p,s) DECIMAL(p,s), DEC(p,s)
DOUBLE PRECISION DOUBLE PRECISION
FLOAT(p) FLOAT(p)
INT, INTEGER INT, INTEGER
MONEY MONEY
NUMERIC(p,s) NUMERIC(p,s)
REAL REAL
SERIAL INT IDENTITY
SMALLINT SMALLINT
TEXT VARCHAR(max)
TIME(p) TIME(p)
TIMESTAMP(3) DATETIME
TIMESTAMP(p) DATETIME2(p)
TIMESTAMP(p) WITH TIME ZONE DATETIMEOFFSET(p)
TINYINT SMALLINT
UUID UNIQUEIDENTIFIER
VARCHAR(n) VARCHAR(n)
XML XML