Use scripting to prompt sync job

[woodpd]

Can I use scripting languages such as ASP or PHP to start a saved job? Basically I have a CMS tool that a client wants to be able to host on a staging server locally and then on request in the web interface, 'publish' the changes to the live server.

Hence I want to know if SQLyog will give me that functionality so I can synchronise my live database with the local one when prompted by as ASP script. (scheduling is no good, it has to be on-demand via my web interface for a seamless solution)

[Ritesh]

Yes 😀

You have to use the correct function in PHP or ASP to execute sja with the job file as parameter.

E.g. In PHP you can do:

Code:

system ( 'sja.exe schema.xml' );

[Author]

Posts