convert PostgreSQL to MS SQL, PostgreSQL to MS SQL converter, migrate PostgreSQL to MS SQL, PostgreSQL to MS SQL migration, free download
FAQ  |  Site map  |  Contact Us
About Us How to Buy Products Discounts Migration Service Support Become a Partner Articles

PostgreSQL to MS SQL


Latest version 2.1 released 01/23/2017

PostgreSQL-to-MSSQL is a program to migrate PostgreSQL databases to Microsoft SQL server or SQL Azure. The program has high performance: 2,5 GB PostgreSQL database is migrated to SQL Server within less than 20 minutes on an average modern system. Command line support allows to script, automate and schedule the conversion process.

Features

  • PostgreSQL to MS SQL converter supports all versions of PostgreSQL and Microsoft SQL (including SQL Azure)
  • Verified support for Heroku 
  • The program converts indexes and foreign keys with all necessary attributes
  • Option to merge PostgreSQL data into an existing MS SQL tables
  • Option to convert individual tables
  • Option to customize field mapping (modify name, type, default values for every column)
  • Fast conversion engine
  • Command line support
  • Option to export PostgreSQL database into T-SQL script file
  • Stores conversion settings into profile
  • Support for multibyte character sets
  • Quick Launch
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • Does not convert views, stored procedures and triggers
  • Demo version converts only 50 records per table
  • Demo version does not convert foreign keys
    

Requirements

  • PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run PostgreSQL-to-MSSQL from)
  • MS SQL environment (server or client components of MS SQL must be installed on the same machine where you run PostgreSQL-to-MSSQL from)
  • Necessary privileges to write into the destination database
  • Supported OS: Windows XP(SP2 or SP3)/2003/Vista/Server 2008/7/8/10

Quick Lauch

Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description (.p2m) file with left mouse button. This will cause PostgreSQL-to-MSSQL wizard to launch conversion loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.

Export into T-SQL script file

Sometimes, there is no direct access to MS SQL server. For such situations PostgreSQL to MS SQL converter provides option of exporting the source database into local T-SQL script file. The resulting file will contain SQL statements to create all tables, indexes and constraints and to fill tables with the data. Then database administrator will be able to import the script file to the target server. This article explains how to import T-SQL script file to MS SQL server.

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only 50 records for each database table, it does NOT convert queries/views and foreign keys. Test the quality of the demo and come back to place an order if satisfied with the results.

Download trial version of PostgreSQL-to-MSSQL

 

PostgreSQL-to-MSSQL
order single product
$49 ORDER NOW
Two Products Bundle
order MSSQL-to-PostgreSQL + PostgreSQL-to-MSSQL, save $24.5
$73.5 ORDER NOW
MSSQL Migration Toolkit
software pack to convert any data source to MS SQL
and vice versa
$99 ORDER NOW
PostgreSQL Migration Toolkit
software pack to convert any data source to PostgresSQL
and vice versa
$99 ORDER NOW