Data synchronisation schedule

Hello

I have been looking around and can't seen to find if there is a way to set up RedGate to synchronise data between two databases to a schedule eg. once daily.
If there are no features for this in RedGate what is the best way to do this? Some ideas I had were if possible to create a script to this and then run it as a scheduled task or create a program with the API and run it as a scheduled task.

Any Ideas would be great.

Thanks
Liam

tcliam April 06, 2010 20:25

Comments

1 comment

Thanks for your post.

The most common way to automate SQL Data compare will be to use the command line interface.

You can then create a batch file that you can schedule through a Windows Scheduled Task.

Here is some info:
http://www.red-gate.com/supportcenter/C ... 700052.htm

I hope it helps.

Chris Auckland April 08, 2010 11:56

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Data synchronisation schedule

Comments

Add comment