amped.nfo
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.
|
|