Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Version control for Cubes

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-25 : 08:57:51
Vinayak writes "I am trying to find out how to implement version control for a data mart. First of all is it possible? If yes then how? and If not then is there any work around like creating SQL scripts etc. and maintain version of those files.

Thank you

Vinayak Shanbhag"

Tim
Starting Member

392 Posts

Posted - 2002-03-06 : 18:50:13
Just an idea - haven't tried it.

If you backup ("archive") an Analysis Services database, it generates .cab file format. You could load the .cab into Visual Source Safe for version control, or to keep it simple, just create folders named for each version and put the .cab in the corresponding folder.

You would also need to backup the relational database, but you could use the same principle.

hope that helps

Go to Top of Page
   

- Advertisement -