Access to MySQL
Introduction
Access to MySQL is a small program that will convert Microsoft Access
Databases to MySQL.
- Wizard interface.
- Transfer data directly from one server to another.
- Create a dump file.
- Select tables to transfer.
- Select fields to transfer.
- Transfer password protected databases.
- Supports both shared security and user-level security.
- Optional transfer of indexes.
- Optional transfer of records.
- Optional transfer of default values in field definitions.
- Identifies and transfers auto number field types.
- Command line interface.
- Easy install, uninstall and upgrade.
Using Access to MySQL
When you start the program it will run you through a wizard. The wizard will
ask you all the necessary questions to setup the database transfer. In the first
step you are asked to supply the file name of the Microsoft Access Database to
convert.
If your Access database requires you to log in you can specify a user name, password and a system database.
Specify Access database
The destination database and MySQL server connection settings are specified
as shown below. You will have the choice of placing the result in a dump file
instead of transferring it directly to another MySQL database.
MySQL connection and destination settings
You can specify exactly which tables you want to transfer to the
destination database. Just check the box in front of each table name you want to
transfer and click next.
Selecting the tables to transfer
Additional transfer options can be set in the dialog shown
below. Here you can specify if you want to transfer the indexes of the Access
database to MySQL. You can also select not to transfer any records. This will
only create the tables in the destination table and leave them empty.
In both Access and MySQL fields can have default values. When
creating the tables in MySQL the program can preserve the default values
specified in the Access field definition. Also auto number properties of a field
can be transferred if you check the Auto number properties box.
Setting advanced transfer options
After answering all the questions in the wizard you can press Finish.
The transfer will now run until all the selected tables are transferred. When the
transfer is done you will see a small report telling you how much data was
transferred.
The settings of the wizard can be saved in a .ini file.
Installation
You can download the latest version here. After downloading the setup
program you should simply run it to install the program.
Version History
2008-11-28 (3.0.0.108)
- New MySQL 6.0 storage engines added (Falcon, Maria).
- Storage engine now specified using ENGINE= instead of TYPE= in CREATE TABLE statement. This enables support for MySQL Server 6.0.
- Support for complex Access 2007 datatypes: dbComplexByte (102), dbComplexInteger (103), dbComplexLong (104), dbComplexSingle (105)
dbComplexDouble (106), dbComplexGUID (107), dbComplexDecimal (108), dbComplexText (109).
2008-11-10 (3.0.0.104)
- Support for international characters added with UTF8 encoding.
- Default DB engine changed from InnoDB to MyISAM.
- Support for MyODBC 3.x was discontinued. Only MyODBC 5.x is now supported.
- Fields of type currency are now created as DECIMAL(19,4) instead of DECIMAL(19,0).
2008-09-23 (3.0.0.97)
- Fix: The program no longer fails if the database contains linked tables.
2008-07-26 (3.0.0.96)
- New feature: Disable the DROP and CREATE statement for tables.
- New feature: Include column list in INSERT statements.
- Support for MySQL ODBC 5.1.
- Ini files are no longer case sensitive.
- Dependency of Scripting.Dictionary was removed.
2008-01-15 (3.0.0.66)
- Support for Microsoft Access 2007 databases (accdb and accde).
2007-09-02 (2.0.0.64)
- Setup program modified for better Vista support.
2007-05-10 (2.0.0.56)
- Boolean fields are represented as 0 and -1. This is a change from 0 and 1.
- Empty strings are now transferred as a zero length string instead of a NULL value.
- Small improvement performance.
2007-05-07 (2.0.0.48)
- Improved support for decimal and currency fields. Reads precision and scale from the source field.
- Requires MySQL ODBC 3.51.14.0 or later.
- Connection database parameter removed.
2006-03-19 (2.0.0.46)
- Support for password protected Microsoft Access databases. Both shared security and user-level security is supported.
2005-08-30 (2.0.0.41)
- Database name is quoted to improve robustness towards creative database names.
2005-08-27 (2.0.0.40)
- Command line interface fixed.
2005-07-28 (2.0.0.37)
- Support for decimal numbers.
2005-07-27 (2.0.0.36)
- Before this version a table was not copied if no fields were selected. From this version all fields are copied if none is selected. This lets the program react to changes in the original schema.
2005-07-26 (2.0.0.35)
- Select individual fields from the tables to copy
2005-01-22 (1.2.0.31)
- Bugfix: Data type 'Simple' is now supported.
- Feature: You can now save the wizard settings without running the actual conversion.
2004-12-12 (1.2.0.30)
- Mod: Support for ODBC connections for MySQL Server 4.1. This server version requires a reference to an existing database when connecting through ODBC.
2004-11-20 (1.2.0.28)
- Bugfix: Fixes boolean fields with no default value. This error was introduced in 1.2.0.27.
2004-11-19 (1.2.0.27)
- Default boolean values are set to 0 or 1 instead of false or true.
- Bugfix: Handling of empty binary fields fixed.
2004-11-12 (1.2.0.25)
- Help button open online help on web site.
2004-11-09 (1.2.0.23)
- Bugfix: When selecting a dump file in the common dialog it didn't set the value in the wizard.
Additional Resources
|
