|
Access-to-MySQL is a program to migrate Microsoft Access
databases to MySQL server.
Depending on your privileges on the target MySQL server you
can export MS Access data into new database or overwrite the
contents of an existing MySQL database.
Access-to-MySQL Features:
- All MS Access data types
and attributes are supported
- Works with all versions of
Unix and Windows MySQL servers
- Converts indexes with all
necessary attributes
- Converts individual tables
- Converts relationships
between tables
- Merges MS Access data into
an existing MySQL database
- VServer user's option
- Converts password
protected MS Access databases
- Converts MS Access
databases protected with user-level security
- Exports MS Access
databases into MySQL dump file
- Command line support
- Easy-to-use wizard-style
interface
- Full install/uninstall
support
Access-to-MySQL Limitations
- Converts MS Access tables
only (forms, queries, reports are not supported)
- Does not convert system
(hidden) tables
Access-to-MySQL System Requirements:
- Windows 2000/XP or Windows
NT 4 with Internet Explorer 5 or later or Windows 98/ME or
Windows 95 with Internet Explorer 5 or later
- MS Access 7.0 or higher
(ODBC is not required)
- At least 32 MB of
available memory
VServer
user's option
If you are using Virtual Server hosting you probably have no
sufficient privileges to create new databases on the target
MySQL server. For this case we recommend the following
approach:
- ask your Virtual Server
administrator to create blank database for you
- run Access-to-MySQL and
select this database as the conversion target
- click "Yes" when you will
be asked if you'd like to overwrite existing MySQL database
When you
complete these steps, the entire contents of the source MS
Access database will be imported into the specified MySQL
database.
MySQL dump file
Access-to-MySQL allows users to perform deferred conversion
and get more control over the process. Following this way, the
program stores the contents of the source database into a
local dump file instead of moving it to MySQL server directly.
The resulting file contains MySQL statements to create all
tables and to fill them with the data. You will be able to
import this file into existing MySQL database via MySQL client
as follows:
mysql.exe --host=... --user=... --password=... -vvf {MySQL
database name} < {dump file name} |
