Best practice for saving SSAS and copying for DR?

  • I'm currently working locally on a SSAS project I have several hours invested in.

    Is there an easy way to keep saving iterations of the same project into the project folder? It seems when I try to rename and relaunch the file is blank. Kind of strange....

    Querying Microsoft SQL Server 2012/2014 - Certified

  • You could use something like GIT or Visual Source Safe for version and change control. Not necessarily easy (or free) but probably the best way.

    If all you're trying to do is to save different iterations of let's say a cube, it would be possible to take the underlying xml and save it into an appropriately named text file. This would only be feasible if you're just trying to do it for a specific file, not the entire project.

  • Thanks Martin I appreciate the heads up.

    Querying Microsoft SQL Server 2012/2014 - Certified

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

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