Performing an unattended conversion and synchronization with Access2MySQL scheduler

Access2MySQL products have a built-in capability for an unattended synchronization and conversion performed without user intervention. Access2MySQL scheduler is complementary software installed with every copy of the product for no additional charge.

It's the fact that the best way of keeping your databases up-to-date is to setup the regular synchronization. Unfortunately it can be not always possible to remember to do the process routinely and also wait for the procedure to complete. Access2MySQL will allow you to synchronize or convert data on a regular basis without any additional actions and with the minimal efforts. An advanced graphical user interface enables users to intuitively navigate the scheduler and specify necessary options.

For the first time you need to configure the settings in interactive mode in order to use them later to run Access2MySQL program unattended. So the first step to automate synchronization is to create a .sav file where all custom options for unattended execution of synchronization process are contained. In other words to synchronise your databases with the scheduler you should create a .sav file, and then specify this file as a parameter in a command-line on launching the scheduler.

Let's take the following scenario as an example.

Regular Database synchronization

For instance, we need to synchronize specific tables from an Access database to a MySQL database, say, every morning, and then extract altered records from MySQL to a new Access database every evening.

• At "Choose Source" step select MS Access Database as a Source.
• At "Choose Destination" step select MySQL Database as a Destination.
• At "Choose Appropriate Options" step select the mode you need "Synchronize". Here you choose some certain tables to be synchronized.
• At "Execution" step click "Save Settings" button to store your settings in a .sav file (you will need it later to run the program on a schedule). The actual name of the .sav file is irrelevant; however it is a good practice to name the file with a corresponding descriptive name. Let it be morning.sav file. If you want to save your passwords to the .sav file check the corresponding checkbox. Synchronization starts after clicking "Commit".

The same operations should be conducted to convert MySQL data to Access but in this case select MySQL as a source and MS Access Database as a destination. Save these settings to a .sav file (let it be evening.sav).

• In order to launch the application every morning from Access to MySQL you need to determine the following parameters:
  • Click "Add Task" button.
    Select Action Type: Access2MySQL
    Enter the path to your morning.sav file or find it clicking at "Browse" button.
    Click "Sync" radio button in "Version" group box.
    Fill in the Source, SysSource, Dest and SysDest fields in case you didn't saved your passwords to your .sav file at "Execution" step. Click "Next".

  • In the next window specify a name for the task. Let it be "Sync1"
    Click "Daily" to perform the task every day.
    Set convenient start time e.g. 08:00.
    Select a date to start.
    After clicking "Add" the task will be scheduled.

• To schedule the synchronization from MySQL to Access every evening follow the steps:
  • Click "Add Task" button.
    Select Action Type: Access2MySQL
    Enter the path to your evening.sav file or find it clicking at "Browse" button.
    Click "Sync" radio button in "Version" group box.
    

  • In the next window specify a name for the task. Let it be "Sync2"
    Click "Daily" to perform the task every day.
    Set convenient start time e.g. 20:00. Add the task.
    

So your Access database will be synchronized with your MySQL base every morning and every evening without your input. Naturally the computer should be turned on, Access2MySQL Sync installed, access2mysql Scheduler launched (minimized into tray) and the PC should be connected to the Internet.

Synchronize your database every two hours

• In order to launch Access2MySQL Sync every, say, two hours you need to determine the following parameters:
  • Click "Add Task" button.
    Select Action Type: Access2MySQL
    Enter the path to your .sav file or find it clicking at "Browse" button.
    Click "Sync" radio button in "Version" group box.
    Fill in the Source, SysSource, Dest and SysDest fields if needed.
    Click "Next".

  • In the next window specify a name for the task (e.g. "Sync1")
    Click "Daily" to perform the task every day.
    Set the start time to 00:00.
    Select a date to start.
    After clicking "Add" the task will be scheduled.

• You need to add a task with such parameters 12 times. Only names will be different and start time should be set with 2 hour period for every task.
  Example:
  Name of the task: Sync2 Start time 02:00
  Name of the task: Sync3 Start time 04:00
  Name of the task: Sync4 Start time 06:00 etc.
  
  

So your Access database will be synchronized with your MySQL base every two hours without your input.

These are only rough drafts. Surely you can set time which is convenient for you.

We are constantly working on improving our products. You are welcome to make comments or suggestions regarding Access2MySQL Scheduler. Post them to
All your feedbacks are highly appreciated.