Synchronising Databases in SSAS 2005

  • Yaniv Mor

    SSC Eights!

    Points: 936

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

  • andyinsdca

    Grasshopper

    Points: 23

    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

    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.

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

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