PostgreSQL to Microsoft SQL Server Migration.

 DBConvert for MSSQL & PostgreSQL

Version: 3.6.2

Release Date: June 15, 2018

Conversion directions:

  • MS SQL Server → PostgreSQL, MS SQL Dump, PostgreSQL Dump, PHP Script
  • PostgreSQL → MS SQL Server, MS SQL Dump, PostgreSQL Dump, PHP Script
  • PostgreSQL ↔ SQL Azure
  • MS SQL Server ↔ Amazon RDS ↔ PostgreSQL
  • MS SQL Server ↔ Heroku Postgres ↔ PostgreSQL
 Download 24.6 MB  Order from US$ 149
 DBSync for MSSQL & PostgreSQL

Version: 2.9.2

Release Date: Feb. 19, 2018

Synchronization directions:

  • MS SQL Server ↔ PostgreSQL
  • PostgreSQL ↔ SQL Azure
  • MS SQL Server ↔ Amazon RDS ↔ PostgreSQL
  • MS SQL Server ↔ Heroku Postgres ↔ PostgreSQL
 Download 25.3 MB  Order from US$ 149

Using our DBConvert/DBSync applications you can easily synchronize and convert your databases from PostgreSQL to Microsoft SQL Server or to Windows Azure SQL Databases. Amazon RDS PostgreSQL / Heroku Postgres instances as a source or target are also supported. Our wizard-Style interface will guide you through all the steps of performing migration and replication jobs easily and effectively.

In scenarios where you have any server restrictions, you can create MS SQL Dump file with all data out of your PostgreSQL database.

Our software will save you many hours of learning SQL commands since any large PostgreSQL database can be converted approximately in 5-10 minutes.

The DBSync application performs synchronization and replication from a PostgreSQL source to Microsoft SQL Server smoothly due to

three synchronization types (Drop, Insert, Update).

Additionally, our built-in scheduler lets you to launch automatically, with no interaction required from you.
 MS SQL configuration for DBConvert  Windows Azure SQL databases Configuration for DBConvert  PostgreSQL Server configuration for DBConvert  Amazon RDS configuration manual for DBConvert.  Heroku Postgres configuration manual for DBConvert.

Microsoft SQL Server to PostgreSQL

Read information about reverse migration.
 DBConvert Key features.   Built-in Scheduler    Trigger-based Sync  Bulk Insert/ Quantization

Product Highlights

Product Requirements

  • Necessary privileges to write into database on the target MS SQL server (this requirement is optional as there is an option to overcome the restrictions using dump file)
  • Necessary privileges to write into database on the target PostgreSQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)

Screenshots

  1. Workaround for firewalls and access rights
  2. Views translation
  3. Flexible customization for all db elements
  4. Bulk Insert and Quantization options for speed-up processing of big volume of data
  5. Conditional data migration. Data Filters.
  6. Full UNICODE architecture support
  7. Optimal data mapping
  8. Autodetection of potential migration issues
  9. Command line mode. Scheduling
  10. Savable sessions

Latest News

  • Amazon RDS PostgreSQL / Heroku Postgres instances support
  • Parameterized queries implemented. Synchronization/conversion speed increased approximately by 15%.
  • Conversion/Synchronization for SQL Azure added.
  • Conversion/Synchronization speed improvement for large databases. 1 Million of records can be converted/ synchronized in 9 min from PostgreSQL to MS SQL and in 6 min from MSSQL Server to PostgreSQL.
  • Compatibility with PostgreSQL server v.8.3.1 added.
  • SSL technique for encrypted data conversion support.
  • Variable quantization step added.