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)