Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Batch Scripting Data Transfers

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Batch Scripting Data Transfers

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 15, 2012 at 10:03 pm #12619
      apmni
      Member

      Hi

      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

      thanks

    • March 16, 2012 at 5:40 am #33198
      ashwin
      Member

      Hi,

      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.com/faq/content/27/35/en/can-i-execute-more-sja-jobs-at-the-same-time.html

      — Now schedule the job file. Refer FAQ: http://www.webyog.com/faq/content/27/33/en/how-do-i-schedule-a-job.html for more details.

      This way you can “batch process” multiple schedule items sequentially.

      Regards,

      Ashwin

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.