Soft82.com » Windows » Developer Tools » Database » Database Applications » Access2MySQL SYNC 5.0

Access2MySQL SYNC Description

Bi-directional synchronization and convertion for MS Access and MySQL databases

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

* MS Access to MySQL
* MS Access to MS Access
* MySQL to MS Access
* MySQL to MySQL.

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

Application Info

current version 6.0.1
release date Sep 04, 2008
file size 16.84 Mb
registration fee $ 79
Languages
[english] [russian] [french] [german] [greek] [spanish] [italian] [danish]
What's new

* Data mapping feature added
* Customizable data filtering


Screenshots

High speed data conversion and performance
Try it now and make sure that it’s true! DBSync for Access & MySQL 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!

Optimal data mapping
Simple data types assignment for a destination database in one touch. Just choose data types you need for the target fields or the most appropriate data types for the source type and our program will automatically transform types from one specific format to another.

Safe data conversion and database integrity
Don’t care about safety of your data. Our converter will do it for you! DBSync for Access & MySQL supports all MySQL 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 Access & MySQL 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 Access & MySQL 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.

User-friendly interface
User-friendly interface is the outcome of the combined efforts of our team in the field of software usability plus Graphic User Interface design. Working with the converter is specially divided into several stages so the most complex issues of the conversion process are broken down into manageable parts. All documentation is provided with the software for your convenience.

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 planner scheduler;
* Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL;
* High speed data conversion and synchronization. DBSync for Access & MySQL speed noticeably exceeds average showing in this category as the program works with direct access to MySQL server not through ODBC like other similar converters;
* Unicode Support/Connection character sets support:
LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, TIS620, UTF8 (unicode charset);
* Primary keys and Indexes support;
* Foreign keys (relations) 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;
* `ENUM` and `SET` MySQL database types support;
* `GUID` Access database type support;
* `OLE Object` packages support;
* Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
* Skins support;
* Multilanguage Support (English/French/Russian);
* 1-year free upgrades.


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 MySQL server

Access2MySQL SYNC Limitations

Only 10 records will be processed Does not convert system (hidden) tables.

Access2MySQL SYNC Version History

Access2MySQL SYNC Download Button For Your Site

If you want to place a Download Button for Access2MySQL SYNC on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

Access2MySQL SYNC User Reviews

New Database Applications Software

MyDbExplorer Team Edition May 23, 2012 Connect to virtually any relational database backend				SQL Client May 23, 2012 Connect to your database with this tool
Nevron SSRS Vision May 22, 2012 Professional Data Visualization Component Suite for SSRS				DbWrench May 18, 2012 Our goal with DbWrench is to make database design cycles quicker and easier
Sfairadora May 17, 2012 Flexible tool for small databases with functions of spreadsheet and text output				Reportizer May 17, 2012 Database reporting tool
dbForge Schema Compare for Oracle May 16, 2012 Compare and synchronize Oracle databases with ease				DTM DB Stress Professional May 16, 2012 A utility for stress testing the server parts of information systems and applications
LinqConnect May 16, 2012 A fast and easy to use ORM solution				SQL Vehicle Database Download + ASP.Net May 16, 2012 Get the 1904-2013 vehicle data in MSSQL and MySQL formats
Association Manager May 15, 2012 ALL-IN-ONE, Easy to Use and Membership and Event Management Solution for Associations				DataCleaner May 14, 2012 An Open Source application for analyzing, profiling, transforming and cleansing data
SQL 2 Excel May 14, 2012 Import SQL queries in Excel tables				dbForge Schema Compare for MySQL May 14, 2012 Tool to compare and synchronize structures of MySQL databases
Database .NET May 14, 2012 A simple, uniform and intuitive database management tool for multiple databases				ERD Concepts May 14, 2012 Database software for professionals
dbForge Data Studio for SQL Server May 14, 2012 Chief query tool for SQL Server data analysts and developers				ETL-Tools QlikView Connector May 10, 2012 An ideal tool for customers who are working with complex and bad quality data
Log Table Viewer May 10, 2012 Provides a unified logging interface for your SQL code				DbVisualizer Personal May 10, 2012 Helps you with both the development and maintenance of your databases

Last 7 Days Most Downloaded Database Applications Products

DB Load Generator 35 downloads The easy way to test your database setup, server performance or sql query effectiveness				TOra 18 downloads Database management GUI that supports accessing most of the common database platforms
SQLDumper 17 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT				Firebird 16 downloads Firebird is a relational database offering many ANSI SQL-92 features
EMS SQL Manager for MySQL 13 downloads State-of-the-art GUI tool for MySQL Server administration and development				DbVisualizer Personal 13 downloads Helps you with both the development and maintenance of your databases
NGen NHibernate Code Generator 12 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows				SQLite3 9 downloads A command-line access program for SQLite databases
Pdxrbld 8 downloads Utility for checking and repairing Paradox tables				EMS SQL Manager for PostgreSQL 8 downloads Powerful graphical tool for PostgreSQL DB Server administration and development

All Time Most Downloaded Database Applications Products

DB Load Generator 3,342 downloads The easy way to test your database setup, server performance or sql query effectiveness				TOra 801 downloads Database management GUI that supports accessing most of the common database platforms
SQLDumper 6,387 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT				Firebird 3,331 downloads Firebird is a relational database offering many ANSI SQL-92 features
EMS SQL Manager for MySQL 2,065 downloads State-of-the-art GUI tool for MySQL Server administration and development				DbVisualizer Personal 1,069 downloads Helps you with both the development and maintenance of your databases
NGen NHibernate Code Generator 492 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows				SQLite3 256 downloads A command-line access program for SQLite databases
Pdxrbld 128 downloads Utility for checking and repairing Paradox tables				EMS SQL Manager for PostgreSQL 1,478 downloads Powerful graphical tool for PostgreSQL DB Server administration and development