|
Tool
for Converting Access to MySQL Pro
Access-to-MySQL Pro is a next
generation of Access-to-MySQL
program, optimized for bulk database conversion. With
this tool you will be able to convert multiple MS Access
databases per session and reuse conversion settings stored
in a profile. Being enhanced with a lot of handy features
this program makes the conversion process even more
effective.
Features
-
All MS Access data types
and attributes are supported
-
Works with all versions
of Unix and Windows MySQL servers
-
Allows converting
multiple databases per session
-
Special approach for
virtual server users
-
Stores configuration
into profile
-
Exports MS Access
databases into a dump file
-
Command line support
-
Converts indexes with
all necessary attributes
-
Converts password
protected MS Access databases
-
Converts MS Access
databases protected with user-level security
-
Easy-to-use wizard-style
interface
-
Full install/uninstall
support
Limitations
-
Converts MS Access
tables only (forms, queries, reports are not supported)
-
Does not convert system
(hidden) tables
-
Does not convert
relationships between tables
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 Pro
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 Pro 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}
|
