postgresqlms sql

PostgreSQL to MS SQL Migration and Sync

Convert and synchronize your databases from PostgreSQL to MS SQL server or to SQL Azure databases using our powerful software. Wizard style interface will guide you through several steps performing migration and replication jobs easily and effectively.

In case you have any server restrictions, you can stuff MS SQL Dump file with all data out of the PostgreSQL database.

Our software will save you hours of learning SQL commands as any large PostgreSQL db can be converted and synchronized approximately in 5-10 min,.

In addition, our built-in scheduler lets you to lunch automatically, with no interaction from your side.

Read here trial versions limitations

Product highlights

  • Saving data into a PostgreSQL Dump and PHP script for export to PostgreSQL database
  • Direct access to PostgreSQL server, not through ODBC like other similar converters
  • PostgreSQL schemes support
  • Ability to connect to PostgreSQL 9.x/7.4 located on Linux, Solaris, Mac OS X, Window machines
  • Speed conversion with Bulk and Quantization features
  • Views conversion from MS SQL to MySQL and Oracle and back support
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
  • MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
  • MS SQL schemes support
  • Saving data into a MS SQL Dump for export to MS SQL database
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • Speed conversion with Bulk and Quantization features
  • Also see common features for all DBConvert tools

Requirements

  • 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)
  • MDAC 2.8
  • 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)
PostgreSQL MS SQL

Converter from
PostgreSQL to MS SQL

  • 8 Oct, 2013
  • Version 3.3.2
ORDER From $ 149 DOWNLOAD 24.52 Mb

Synchronizer between
PostgreSQL and MS SQL

  • 8 Oct, 2013
  • Version 2.7.2
ORDER From $ 149 DOWNLOAD 25.14 Mb

Two-way database migration in one package. Pay once - get both! Find more information about the reverse migration

From MS SQL to PostgreSQL

Converter+Syncronizer Bundle! Take 25% off regular price

New Features

  • 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.

Screenshots

PostgreSQL to MS SQL: Benefits

  • 1 - Workaround for firewalls and access rights
  • 2 - Views conversion
  • 3 - Flexible customization for all db elements
  • 4 - Bulk and quantization for speed up of big volume of data processing
  • 5 - Conditional data migration
  • 6 - Full UNICODE architecture support
  • 7 - Optimal data mapping
  • 8 - Verification of potential migration issues
  • 9 - Command line mode & scheduling
  • 10 - Savable sessions