Hi, I'm still a new user, but I really like SQLyog a lot. My question is:
1. I am working with 50 different databases (identical structure, different US states)
2. I would like to be able to automate some SQL code that I have written (e.g., alter table, create index, delete records that contain fields with zero values, etc.) so that they could be run for all 50 databases without me sitting here and running the code by selecting each database, then executing code via 'favorites', then waiting until the program is finished, then moving on to the next database. I'm very hopeful that SQLyog can help me automate this process so that I could have it run unattended, overnight and such.
3. I know that there is a way to schedule backups and even data synch, but this code is different, it has to do with modifications of the databases/tables, not backing up or synching different databases.
I have looked through the help files and have not been able to find a way to schedule a process which repeats s set of SQL operations for 50 different databases.
Is this possible? If so, how?
thanks!
Brian
