Re: Scheduling MSSQL Workbench to execute or export on a daily basis to MYSQL

[Milosz Bodzek]

Well it's pretty easy. First run migration wizard in MySQL Workbench and in 'Data Transfer Setup' step choose 'Create shell script to copy the data from outside of Workbench'. Open generated file and fill with source and target db passwords. To wbcopytables command you can add --resume parameter (if you want copying only new data) or --truncate-target (if you want delete all data and copy it again). After that save your file and write in command line crontab -e to edit your crontab file. Now write your crontab job like:
0 18 * * 1-5 /path/to/copy_migrated_tables.sh
That will copy your data on 6pm every weekdays. That's it.

--
Milosz Bodzek
MySQL Developer Tools