Jump to content


Photo

Batch Scripting Data Transfers


  • Please log in to reply
1 reply to this topic

#1 apmni

apmni

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 15 March 2012 - 10:03 PM

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

#2 ashwin

ashwin

    Advanced Member

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

Posted 16 March 2012 - 05:40 AM

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.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.

Regards,
Ashwin

Attached Files






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users