SQL Server to PostgreSQL FAQ

On this page you can find the most frequently asked questions regarding SQL Server to PostgreSQL converter. If your question is not answered here, please contact us via Feedback Form

• What kind of database objects are migrated by the tool?
• What versions of SQL Server and PostgreSQL are supported?
• How to specify custom ports for SQL Server and PostgreSQL?
• Does SQL Server to PostgreSQL converter support automation?
• How to configure SQL Server for work with the database migration tool?
• How to connect to Azure SQL from the converter?
• How to change destination table name?
• How to change name/type of table columns?
• How to rename column in the resulting PostgreSQL table?
• Why some indexes are created with "00000", "00001", ... suffixes added to the name?
• Is it possible to run the product in the command line mode or call it from batch script?
• I cannot find resulting SQL script file and/or log file. Why?
• How to migrate SQL Server tables from all schemas?
• How to migrate only fragments of data, not entire table?

Errors

• The ordinal XXXX could not be located in the dynamic link library LIBEAY32.dll
• FATAL: no pg_hba.conf entry for host...
• The program can't start because LIBPQ.dll is missing from your computer...