Too Complex For Sja?

[Jan.S]

Hi,

Here are the answers:

1. Create a job file for import

2. Create a job (using SQLyog's Scheduler and Reporting Tool) to execute the required query, or create a trigger to automatically execute the query when data is added.

3. Create a job file for data sync

Q1. The jobs cannot be combined into a single job. However you can write a batch script to run these jobs, and then schedule it, so it will be synchronized.

Q2: You will need to add another job to run a query to get what information you require to add into the other table. This can also be added to the batch script

Q3: With SJA this is the best way to accomplish what you want to do. We don't use or comment on other tools, so we can not tell you if there is a better way to do this using some other tool.

Regards,

Janani

[Author]

Posts