From:       To:      
Home > Documentation > SQL Server to PostgreSQL > FAQ

How to migrate SQL Server tables from all schemas?

SQL Server to PostgreSQL converter allows to specify source and target schemas during migration. To extract and migrate full list of schemas from the original database, select "Full replication" option on the "Conversion Settings" wizard page.

SQL Server to PostgreSQL: Conversion Settings

Use this mode to preserve full names of all tables the same as in the original database (for examle "schema1"."table1"). In this mode SQL Server default schema "dbo" will be also migrated to PostgreSQL unchanged. It will not be converted into PostgreSQL default schema "public".

Have more questions? Contact us