View Image

DBSync for MS SQL & PostgreSQL is a database synchronizer which performs MS SQL to PostgreSQL and PostgreSQL to MS SQL database conversion and synchronization simply by configuring several options in wizard-like application.

This tool gives you chance not only convert your data with synchronization, but there is also a possibility to choose particular number of tables for synching. You can organize application work using command line parameters and choose whether to copy the identical records from source database to the destination database or not.

DBSync for MS SQL & PostgreSQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from:

MS SQL to PostgreSQL
MS SQL to MS SQL
PostgreSQL to MS SQL
PostgreSQL to PostgreSQL
Synchronize and convert databases from MS SQL to PostgreSQL or from PostgreSQL to MS SQL rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! DBSync for MS SQL & PostgreSQL is also applicable for PostgreSQL database synchronization and migration to another PostgreSQL database. Moreover, DBSync for MS SQL & PostgreSQL is quite well for MS SQL database synchronizing and migration to another MS SQL database.

Features:

Microsoft SQL Server Express 2005/2008 and Microsoft SQL Server 2000/2005/2008 support
Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
Interactive (GUI) mode / command line mode
Foreign key (relations) support
Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MS SQL/PostgreSQL internal purposes) with a substitute symbol
Insert-synchronization, Update-synchronization and Drop-synchronization available
Unicode (utf-8/ utf-16) for MS SQL Server support, all possible encoding support
Unicode Support/Connection character sets support for PostgreSQL server:
LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, UTF8 (unicode charset)
Primary keys and Indexes support
MS SQL and PostgreSQL schemes support
Advanced customization options:
- partial selection for database objects to be converted.
- database objects (tables, fields, indexes) renaming before conversion.
- detection of possible conversion errors at customization stage.
Sessions support - all your settings can be saved and restored then;
Binary data type conversion support
Support for AutoIncrement fields conversion
Support for field default values conversion
Automation of the conversion process with task scheduler
High speed of data conversion
Ability to connect to PostgreSQL database servers located on all Unix-like and Windows machines.
Skins support;
Multilanguage Support (English/French/Russian);