DBConvert/ DBSync for MSSQL and PostgreSQL cross database migration software helps to convert and synchronize your database from Microsoft SQL Server to PostgreSQL / Amazon RDS PostgreSQL / Heroku Postgres and in any other possible combination of source and target . As well, Windows Azure SQL Databases may be set up as source or target. Programs are able to connect to any local or remote MS SQL Server and PostgreSQL instances.

Although both MS SQL Server and PostgreSQL databases are ANSI-SQL compliant, there are still differences between their SQL syntax, data types, case sensitivity, and it makes transferring data not so trivial if you try to do that manually.

The whole database can be copied from a MS SQL Server database to a PostgreSQL database or you can specify partial set of data in customization stage for migration.

Using Dump files and PHP scripts as destination would be alternative if there is no direct access to servers.

Once data is migrated, sync of all updates in the MSSQL db to the PostgreSQL db can be performed smoothly with DBSync for MSSQL and PostgreSQL.

Your database will always be up-to-date due to three sync types (Drop, Insert, Update).

Run the program at user-specified time intervals specifying settings at Scheduling stage. Scheduler runs automatically and unattended in the background.

Product Highlights

Amazon RDS PostgreSQL DB Instance support
Speed conversion with Bulk and Quantization features
PostgreSQL schemes support
Heroku Postgres as a source or target database.
MS SQL Server (Express) 2000/2005/2008/2008 R2/2012/2014, SQL Azure support
Views conversion from MS SQL to MySQL and Oracle and back support
Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
Direct connection to PostgreSQL server
Speed conversion with Bulk and Quantization features
MS SQL schemes support
Saving data into a MS SQL Dump for export to MS SQL database
Saving data into a PostgreSQL Dump and PHP script for export to PostgreSQL database
Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
Amazon RDS SQL Server DB Instance support
Ability to connect to PostgreSQL 9.x/7.4 located on Linux, Solaris, Mac OS X, Window machines

Only for V.I.P