Automation feature

[Lysia]

I work at The Juilliard School in New York City. We currently use SQLyog to upload data from our events scheduler (which uses MS SQL) into our intranet database (which uses MySQL). Right now, I am the person responsible for running the procedure, which consists of manually doing the ODBC import; selecting the tables, transforming them, and then running the process. We were told when we purchased SQLyog that at some point, a feature would be added that allowed this upload to be done automatically. Is there any word on when this will become available?

Any help on this is greatly appreciated.

[CalEvans]

I don't have the answer to your specific question but I can answer th one you did not ask. It should be very easy to write a script in VBS or PHP to perform the update for you. Once you know it is operating properly, you can simply use the Windows Task Scheduler to run it as often as you like.

BTW, it's cool to know that an organization as reputable as Julliard uses MySQL.

HTH,

=C=

[Lysia]

Thank you for responding to my query! I am not positive, but I think someone here tried to write a script, and it didn't work for some reason. What I do know is that when my boss agreed to purchase this tool, he was told that the next release of SQLyog would include an automation feature. He wasn't given a time frame, however, so I suppose it's possible that this is something that won't be happening for some time. Do you have a PHP script that has worked for you? We do have staff here that know PHP, but perhaps there was someting missing that they couldn't work out. I'd be grateful if you could point me in the right direction, but I know that script-writing can be quite a process so I appreciate if you don't just want to hand over something that you worked very hard on. To be honest, I'm new to MySQL and PHP, and this is my first small project with it.

[Shadow]

The upcoming version of SQLyog (3.6) does have scheduler support. As of now, only MySql-toMySql synchronization can be scheduled, but I'm sure that the later versions will allow more functions to be scheduled, including ODBC import. The only current solution I can think of right now is to do what CalEvans suggested: to write a script and automate it. I would suggest, however, to use VBScript or even a smal VB program to do the job because it can be debugged more easily than PHP and there is no need for a web server.

[Author]

Posts