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