Data synchronisation schedule

tcliam

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

Chris Auckland

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.