Jump to content


Batch Scripting Data Transfers

  • Please log in to reply
1 reply to this topic

#1 apmni



  • Members
  • Pip
  • 1 posts

Posted 15 March 2012 - 10:03 PM

I'm new to sqlyog. Is it possible to run the db transfer/copy from one database to another using a batch script?
I want to do a scheduled backup for a production database and transfer to a backup database at the same time.
I'm hoping others have come across this problem as well.
Appreciate any help


#2 ashwin


    Advanced Member

  • Members
  • PipPipPip
  • 275 posts
  • Gender:Male
  • Location:Bangalore, India

Posted 16 March 2012 - 05:40 AM


You can achieve this by following these steps:
-- Create job files for Scheduled backup and Database synchronization.
Select "Save Job File" in both the wizards to run the task manually. With this option, at the following page of the Wizard you should indicate the name for the Job File which will be saved in the XML format. Refer attached image.
-- Write a .bat file to execute more SJA jobs at the same time. Refer FAQ: http://www.webyog.co...-same-time.html
-- Now schedule the job file. Refer FAQ: http://www.webyog.co...dule-a-job.html for more details.

This way you can "batch process" multiple schedule items sequentially.


Attached Files

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users