Synchronising Databases in SSAS 2005

Question

Post reply

Synchronising Databases in SSAS 2005

Yaniv Mor

SSC Eights!

Points: 936
More actions
February 7, 2007 at 8:44 pm

#369443

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/ymor/2864.asp

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

andyinsdca Grasshopper Points: 23 More actions · Answer 1

Can this be automated so that we can use this to keep a mirror copy of a database up to date?

Yaniv Mor SSC Eights! Points: 936 More actions · Answer 2

Yes, synchronisation scripts can be saved and then embedded in a SQL job to be run at regular intervals.

The last step in the synchronisation wizard prompts you either to synchronise now or save the script for a later use. Simply save the script and then use it in a SQL Agent job.