AllBusinessTools

 

 

 

Product List

Home

 

Database Management

MSSQL to MYSQL

Access to MYSQL

Paradox Converter

Access to Oracle

Oracle to Access

123 Lotus Converter

MYSQL to Oracle

Excel Converter

MYSQL to Access

Clarion Converter

Access Converter

DBF Converter

DBF to MYSQL

Oracle to MYSQL

CSV Converter

Access to MYSQL Pro

SQLRD

db Organizer Deluxe

Excel Everywhere

CHM Converter

HLP Converter

 

 

Product List

Home

 

Financial

Personal Finance

Bookkeeping Accounting

Tax Preparation

Invoice Software

Construction Estimation

Business Valuation

Stock Analysis

Real Estate

 

Documents

PDF Converting

Database Management

Excel Tools

 

Computer

Anti Virus Software

Internet Filtering

Security Suite

Anti Spyware

Firewall Software

Registry Repair

BackUp PC

Disk Management

E-mail Management

Network Management

 

Organizational

Business Organizer

FlowChart Software

Credit Repair / Legal

Background Check

Business Plan

Project Management

Inventory

Speed Camera Blocker

 

Digital Software

DVD Copy

DVD Ripper

iPod Converter

Video Converter

 

 

Web Site     

About Us

Contact Us

Privacy Policy

 

 

 

 

 

 

 

 

 

 

 

Access2MySQL Pro Convertor is a program which gives an opportunity to perform MS Access (mdb) to MySQL and MySQL to Access database conversions simply by having configurated several options of wizard-like application.

Database Management Software

 

Access2MySQL Pro

   Access2MySQL Pro

$55.00  Now Only $52.55    Purchase Now 

5% Off

Access2MySQL Sync

$49.00  Now Only $46.55    Purchase Now 

 

Access2MySQL Pro Review

Access2MySQL Pro Convertor is a program which gives an opportunity to perform MS Access (mdb) to MySQL and MySQL to Access database conversions simply by having configurated several options of wizard-like application.

Convert your dbs using professional tool. Do it faster, more reliable and comfortably. Whether you want to copy a whole database or convert a number of tables, Access2MySQL Pro is at your service.

Access2MySQL Pro is a database migration tool for data conversion from MS Access database (.mdb file) to MySQL server and MySQL db to Microsoft Access.

You can convert Access to MySQL or visa versa MySQL to Access simply by configuring several options through Wizard interface or in command line mode. Ability to organize application work using command line parameters is supplemented with a built-in scheduler so you can run the program without user input after scheduling.

Along with general functionality - data importing / exporting - this easy to use converter allows you to store your data to PHP script. When using PHP script the speed of data export will be much faster than if MS Access databases were copied to MySQL database directly because the copying to MySQL database is executed with utilization of the server where the particular script is launched.

If a direct access to your MySQL base is denied (no sufficient privileges) you can save your data into a dump file to overcome such restrictions. The primary function of the MySQL privilege system is to authenticate a user connecting from a given host, and to associate that user with privileges on to select, insert, update, and delete a database. The SELECT, INSERT, UPDATE, and DELETE privileges allow you to perform operations on rows in existing tables in a database. The privilege system ensures that all users may perform only the operations allowed to them. Thus in case you have no privileges to create or modify a database on the target MySQL server there is an opportunity to save your data into a dump file.

Access2MySQL Pro converter fixes the contents of the source database into a local dump file instead of sending it to MySQL server directly. The destination file will consist of MySQL statements to create all tables and to fill them with the data. Using this dump file MySQL server administrator will add data to your MySQL database.

 

Features:

  • Interactive (GUI) mode / command line mode;
  • Ability to choose a particular number of tables to be converted.
  • Saving data into a dump file, PHP script for export to MySQL database;
  • Ability to use .sav file where all the settings of the program are stored when you run the program from command line;
  • Support for MS Access Work Groups;
  • Support for AutoIncrement (AutoNumber) fields conversion;
  • Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MySQL internal purposes) with a substitute symbol.
  • According to the MySQL restrictions, the dialog is shown up to force you to edit all incorrect table names. By default, each "garbage" symbol is replaced with '_' symbol.
  • Support for field default values conversion;
  • Automation of the conversion process with a built-in scheduler
  • Ability to select ISAM, MYISAM, HEAP, InnoDB, BDB table types when copying data to MySQL or MySQL Text (dump file)
  • High speed of data conversion. Access2MySQL Sync 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.

Important notices

  • Does not convert system (hidden) tables.
  • Does not convert relationships between tables.

 

 

 

Access2MySQL Pro

$55.00  Now Only $52.25    Purchase Now 

 

 

 

Access2MySQL Sync

Access2MySQL Sync is a data synchronization tool that presents bidirectional conversion (MS Access - MySQL) unlike other similar data migration tools, which commonly perform only one-way conversion.

In case you consider moving to MySQL after you convert your data from MS Access to MySQL server you can face the necessity to bring the data back to your Access base (e.g. it was modified by users of your MySQL db through Web Interface and you want to add this modified data to the MS Access database).

In case you don't want to convert all tables from a database, you can specify only those tables you would like to convert. There is opportunity to copy selected tables either in interactive mode (GUI) or launch the copying process through the command line.

You have an opportunity to run the conversion process un-attended on a user defined schedule. Built-in scheduler will launch Access2MySQL program without user input at a time that is most convenient for you.

Along with this general functionality, Access2MySQL Sync supports database synchronization to avoid the unnecessary data duplication.

Database synchronization:

Generally synchronization means the process of uploading and downloading information from two or more databases, so that each is identical. In view of MS Access to MySQL conversion synching can be defined as an operation that keeps distributed databases in agreement and normally refers to the routine updating of an MySQL database with information from an MS Access database and vice versa.

Access2MySQL Sync gives you an opportunity to update only the tables that have changed since the last sync without converting the whole database in order to minimize the amount of data that will have to go over the network. This synchronization feature is very useful when updating a database from another one or adding data from several source databases to only one destination database (special emphasis is laid on MS Access to MS Access synchronization).


Features of database synchronization:
  • There is an option whether to copy identical records to a destination database or not
  • Accurate external links handling when synchronizing from MS Access to MS Access

 

Features

  • Database synchronization (Access - Access, Access - MySQL)
  • Interactive (GUI) mode / command line mode;
  • Ability to choose a particular number of tables to be converted.
  • 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 MySQL internal purposes) with a substitute symbol.
  • Support for AutoIncrement (AutoNumber) fields conversion;
  • Ability to use .sav file when starting the program from command line;
  • According to the MySQL restrictions, the dialog is shown up to force you to edit all incorrect table names. By default, each "garbage" symbol is replaced with '_' symbol.
  • Support for field default values conversion;
  • Automation of the conversion process with a built-in scheduler
  • Ability to select ISAM, MYISAM, HEAP, InnoDB, BDB table types when copying data to MySQL
  • High speed of data conversion. Access2MySQL Sync 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.

Requirements

  • Windows 98/NT/Me/2000/XP/2003/ or later
  • At least 32 MB of RAM
  • Necessary privileges to write into database on the target MySQL server

Important notices

  • Does not convert system (hidden) tables.
  • Does not convert relationships between tables.

Access2MySQL Sync

$49.00  Now Only $46.55    Purchase Now

 

 

 

Comparison between Pro and Sync

 

Features Access2MySQL
Sync
Access2MySQL
Pro
 
Convert .mdb
(MS Access) databases
to MySQL
Yes Yes
 
Convert MySQL
to .mdb
(MS Access) databases
Yes Yes
 
Support of all
MS Access data types
and attributes
Yes Yes
 
Work using
command line
Yes Yes
 
Support for MS Access
Work Groups
Yes Yes
 
Ability to select
the tables
to be processed
Yes v
 
Database synchronization Yes  
 
Saving data to local dump file   Yes
 
Saving data to PHP script file   Yes
 
Select table type:
MyISAM, HEAP, BDB, InnoDBor ISAM
Yes Yes
 
Built-in Scheduler Yes Yes

 

 

Full Product List

Access2MySQL Pro
ccess2MySQL Sync
Access2PostgreSQL PRO
AccessForms2Web (PHP&MySQL Editon)
DMControls.CharMap .NET control
DMControls.ColorMixer .NET control
DMControls.ColorPicker .NET control
DMControls.FontListCombo .NET control
DMControls.Lens .NET control
ScreenDiscoverer