DBSync for MS Access and PostgreSQL

DBSync’s Database integration helps you get the maximum value out of your applications, by integrating them with any cloud or on-premise database. With DDBSync’s Database integration helps you get the maximum value out of your applications, by integrating them with any cloud or on-premise database. With DBSync’s fast and easy integration, you can extract, transform and load data from any cloud or on-premise application to a database of your choice and vice-versa.BSync’s fast and easy integration, you can extract, transform and load data from any cloud or on-premise application to a database of your choice and vice-versa.

Synchronize and convert databases from MS Access to PostgreSQL or from PostgreSQL to MS Access 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 Access & PostgreSQL is also applicable for PostgreSQL database synchronization and migration to another PostgreSQL database or to another PostgreSQL server. Moreover, DBSync for MS Access & PostgreSQL is quite well for copying and synchronizing MS Access database with another MS Access database.

High speed data conversion and performance
Try it now and make sure that it’s true! DBSync for MS Access & PostgreSQL establishes a direct connection to source and destination databases. Thanks to improved quality of synchronization, data is transferred much faster and more accurate in comparison with lots of universal synchronizers which use ODBC or ADO. It is developed exactly for solving your problem with minimum effort and time!

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.

Safe data synchronyzation and database integrity
Don’t care about safety of your data. Our converter will do it for you! DBSync for MS Access & PostgreSQL supports all PostgreSQL server and MS Access data types (including `BLOBS` and `OLE Object` packages). Primary keys, indexes and foreign keys (relations in MS Access) are supported in the best way.

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.

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.

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 Access & 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 loose time for configuring source, destination database and other customizations for conversion process.

Command line mode
Run DBSync for MS Access & 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

• Insert-synchronization, Update-synchronization and Drop-synchronization available;
• Database objects (tables, fields, indexes and foreign keys) remapping;
• Interactive (GUI) mode / command line mode;
• Support for MS Access Work Groups;
• Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
• Automation of the conversion and synchronization process with task scheduler;
• High speed data conversion and synchronization. DBSync for MS Access & PostgreSQL speed noticeably exceeds average showing in this category as the program works with direct access to PostgreSQL server not through ODBC like other similar converters;
• Unicode Support/Connection character sets support:
  MULE_INTERNAL, SQL_ASCII, LATIN1, LATIN2, LATIN5, LATIN7, KOI8, ALT, WIN1250, WIN, WIN1256, ISO_8859_7, ISO_8859_8, UNICODE (utf-8) ;
• Primary keys and Indexes support;
• Foreign keys (relations) support;
• PostgreSQL schemes support;
• Advanced customization options:
  – partial selection for database objects to be converted or synchronized;
  – database objects (tables, fields, indexes, foreign keys) tuning up before synchronization;
  – detection of possible conversion and synchronization errors on customization stage.
• Sessions support – all your settings can be saved and restored later;
• Data array support;
• `GUID` Access database type support;
• `OLE Object` packages support;
• Ability to connect to PostgreSQL database servers located on all Unix-like and Windows machines.
• Skins support;
• Multilanguage Support (English/French/Russian);
• 1-year free upgrades.
• • PUBLISHERDMSoft Technologies
  • DOWNLOADS621
  • LANGUAGE
    French
  • TYPEDatabase
  • SYSTEMWindows XP

  OTHER LANGUAGES

  DOWNLOAD

  • SHAREWARE

  DBSync for MS Access & Po synchronizes and converts data from MS Access to PostgreSQL server databases and from PostgreSQL to Access with synchronization. It helps to keep your databases up-to-date when moving to PostgreSQL. Features are data export\import, database synchronization, high-speed synchronization via command line and GUI, built-in scheduler. This data synchronization tool allows you to convert foreign keys, indexes and Primary keys.