PostgreSQL to MSSQL FAQ

[PostgreSQL to MS SQL Converter]  [Tutorial]  [Download]  [Buy]

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

What kind of MS SQL data is converted to PostgreSQL?
PostgreSQL to MS SQL migration tool converts table definitions with all necessary attributes, records, indexes and foreign keys. It does not convert views, triggers and stored procedures. Demo version converts only 50 records per table and does not convert foreign keys and views.
Go to Top

What versions of SQL Server are supported?
PostgreSQL to SQL converter supports Microsoft SQL Server 2000, 2005, 2008, 2012, 2014, 2016, Azure SQL.
Go to Top

What versions of PostgreSQL are supported?
PostgreSQL to SQL Server migration tool supports PostgreSQL 9.0, 9.1, 9.2, 9.3, 9.4 and 9.5.
Go to Top

Does PostgreSQL to MS SQL converter support automation?
The product does not have automation capability. However, there is command line version p2magent.exe in the installation folder. This version can be called from batch script that allows to automate conversion using Windows Task Scheduler. Refer to 'Command line' article of the product documentation to learn more about p2magent.exe.

How to bypass error "The ordinal XXXX could not be located in the dynamic link library LIBEAY32.dll."?
Check that you have PostgreSQL installed on the same machine where you run the application from. Also please make sure that the path to PostgreSQL installation folder is in $PATH system variable. If the problem persists, copy pgs2mss.exe into PostgreSQL BIN subfolder and try to run it from there.
Go to Top

How to bypass error "The program can't start because LIBPQ.dll is missing from your computer. Try reinstalling the program to fix this problem."
LIBPQ.DLL is a part of PostgreSQL installation that is required for using PostgreSQL-to-MSSQL. Check that you have PostgreSQL installed on the same machine where you run the application from. Also please make sure that the path to PostgreSQL components folder is in $PATH system variable. If the problem persists, copy pgs2mss.exe into PostgreSQL BIN subfolder and try to run it from there.
Go to Top

Does PostgreSQL to MS SQL conversion tool require PostgreSQL server installation?
The product requires that server or client components of PostgreSQL are installed on the same machine where you run the converter.
Go to Top

How to uninstall PostgreSQL to SQL Server converter?
The product can be removed from computer using "Add or Remove Programs" option in the Windows Control Panel.
Go to Top