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.

Safe data synchronization and database integrity
Don't care about safety of your data. Our converter will do it for you! DBSync for MS SQL & PostgreSQL supports all base data types of MS SQL Servers 2000/2005 and PostgreSQL server data types. Primary keys, indexes and foreign keys are supported in the best way.

Preverification of possible conversion errors.
Verify possible conversion errors before the conversion process gets started! To prevent is better than to correct! Our tool displays errors and potential problems with your table objects beforehand. Some errors that could bring to the conflict on a destination database are easy to eliminate by a small reconfiguration of the conversion process issues in one touch.

Update, Insert and Drop synchronization
Keep all your databases up-to-date. Insert synchronization is meant for new records adding from a source to a destination database. Update synchronization is meant for replacing of the altered records in destination database. Drop-synchronization allows users to delete records from destination database if these records were removed in source. Together they allow keeping distributed databases in agreement.

Conditional data migration
Manage your database conversion with the help of integrated data filters. Define filtering conditions and retrieve only the specific data that you need for conversion. Due to our data filters you get more control on data migration process.

Database objects (tables, fields, indexes and foreign keys) remapping for synchronization
Synchronize databases with different structures easily! All database objects (fields, indexes and foreign keys) can be remapped on the customization stage.

Full UNICODE architecture support
DBSync for MS SQL & PostgreSQL is based on full Unicode architecture with multibyte character sets support. It is compatible with a lot of character sets (including Unicode utf-8) and associated standards.

Customize your data synchronization process and database copying totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Savable sessions
Save your sessions and use them again if you do not want to lose time for configuring source, destination database and other customizations for synchronization process.

Command line mode
Run DBSync for MS SQL & PostgreSQL as a part of your automate solution to activate it from a command line with saved session name as a parameter.

Flexible Scheduling
Raise the productivity of your work up. Conversion and synchronization task managing is performed in all DBConvert tools with built-in Scheduling stage. Using sessions and batch files as parameters the scheduled tasks will automatically work as services in background mode giving you an opportunity to keep them unattended.

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);

Requirements

• Windows Vista/XP/2000/NT (NT only with Internet Explorer 4.01);
• At least 32 MB of RAM
• Necessary privileges to write into database on the target MS SQL/PostgreSQL server.
• MDAC 2.8

Important notices

• Does not support Microsoft SQL Server Desktop Engine
• Does not convert system (hidden) tables.

If you have questions/comments about our program - please don't hesitate to direct them to contact form.
Your feedback is highly appreciated. Try DBSync for MS SQL & PostgreSQL converter before you buy You are welcome to evaluate a trial product copy which allows you to process first 50 records of each table. You can upgrade this trial version to a fully-operational copy by purchasing and entering a valid registration code.

Almost all our converters are also available in English, French, Russian, German, Spanish, Italian, Greek and Danish.
Get a free license for translation of our converter into your native language. Contact us if you like this proposal!

---

The names of actual companies and products mentioned herein may be the trademarks of their respective owners