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.
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 youVinayak 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 |
|
|
|
|
|