The following screen shots shows you a sample screens of Access-MySQl Converter wizard.
Select conversion way:
This first step is
to select the conversion direction. You convert from any MS
Access database to MySQL server or vice
versa. You can also start with a saved conversion task.
Task Manager:
* NEW *
Task manager is a new feature in version 3.0 that allows you
to control your saved conversion tasks. You can add and
delete tasks and view each saved task properties and logs.
Select access tables to convert
After select the
source access database, this step allows you to select only
the tables you want to convert. You can also control which
fields to convert by clicking the "Advanced" button.
Select fields to be converted for each
table:
The
advanced options dialog gives you more control over the
conversion process. Here you can select which fields to
convert for each selected table in the previous step.
Special characters options
:*
NEW *
The special characters tab gives you the ability to replace
certain characters (like: / . \ * # $) with any character
you specify. You can also add your own characters or
keywords to replace. Character replacement can be done to
database structure, records or both.
Connect to MySQL server:
This
step lets Access-MySQL connects to the target MySQL
server. Note that you can instruct Access-MySQL Converter to
remember your connection info so you don't have to enter them
the next time. Connection data are saved in an encrypted way
to protect your data from any unauthorized access.
Select conversion mode:
The
"Conversion Options" step is designed to let you control how
your MS Access tables are migrated to MySQL. You can select
either to migrate your tables into a new MySQL database or
into an existing one. If You choose to convert into an
existing one, you can also control whether to overwrite the
target MySQL data or synchronize it with the source
tables.
Data Filters:
* NEW *
Data Filters is a powerful new feature in version 3.0, It lets
you define custom criteria to to filter which records to be
converted per each table. Using this simple condition
builder you can easily and quickly build up to 3 conditions
per table.
Schedule conversion:
Scheduling is one of the
most powerful features of Access-MySQL converter. This dialog
gives you the ability to schedule the whole conversion process
for automated later execution. It simply adds an entry to the
windows "Scheduled Tasks" to run Access-MySQL Converter every
certain period of time that you determine.
