View a markdown version of this page

SQL Server to PostgreSQL - AWS Database Migration Service

SQL Server to PostgreSQL

This section describes the default rules that DMS Schema Conversion applies when it converts a Microsoft SQL Server source database to Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL.

SQL Server and PostgreSQL differ in how they handle identifier case, qualify objects by database and schema, name parameters and variables, and provide built-in functions. Some SQL Server objects have no direct equivalent in PostgreSQL. DMS Schema Conversion resolves these differences automatically where it can. When an object needs manual work or review, it reports an action item. The following topics describe the default rules for each area of the conversion.