ms sqlpostgresql

MS SQL to PostgreSQL Migration and Sync

Our cross database migration software allows you to convert and synchronize your data from MS SQL to PostgreSQL Server. Programs are able to connect to any local or remote MSSQL and PostgreSQL databases.


PostgreSQL advantages over MS SQL Server:

  • MS SQL Server is a proprietary database from Microsoft, while on the other side, PostgreSQL is developed and maintained by a global community of open source developers and companies. So if cost is an issue, then definitely you should go with PostgreSQL.

  • PostgreSQL is a cross platform database engine is available for Windows, Mac, Solaris, FreeBSD and Linux while SQL Server only runs on Windows OS. PostgreSQL is completely free while MSSQL Server cost depends on the number of users and database size.

  • MSSQL is quite greedy on memory even when idle while PostgreSQL is relatively lightweight.

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.

With help of our migration tools your MSSQL database will be migrated to PostgreSQL accurately and fast.

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.

Once the data is migrated, a method of syncing any updates in the MSSQL db to the PostgreSQL db is performed smoothly with our Synchronization tools.

The tool provides direct access to an SQL Server, but when you need to overcome restrictions PostgreSQL Dump and PHP scripts may be generated.

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

Read here trial versions limitations

Product highlights

  • 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
  • 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
  • Also see common features for all DBConvert tools

Requirements

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

Converter from
MS SQL to PostgreSQL

  • 8 Oct, 2013
  • Version 3.3.2
ORDER From $ 99 DOWNLOAD-19 Mb

Synchronizer between
MS SQL and PostgreSQL

  • 8 Oct, 2013
  • Version 2.7.2
ORDER From $ 99 DOWNLOAD - 19.7 Mb

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

From PostgreSQL to MS SQL

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

MS SQL to PostgreSQL: 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