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 |
|
Kirun
Yak Posting Veteran
60 Posts |
 Posted - 2002-05-11 : 08:35:37
|
| is there any way that the cubes and diemsion (virtual and shared) be portabel.. so that i dont have to carry my system to clients to show the result ...i have made all the cubes and dimesnion from the wizards so i dont have there query.. is there nay way so that i can run query (MDX) and it works like it works in case of tabel structure...... plz help..thanks in advance |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-12 : 19:39:44
|
You can create an archive of a database using the command line msmdarch /a Server "OLAPDataPath" "DatabaseName" "BackupFileName"or more simply by right clicking on it in AS manager and choosing Archive. You can then restore it to any system and query it (pressuming its been processed). If the source databases/tables exist at the client you can even change the connection string and rebuild the cube using live data. We use a form of log shipping ("cube shipping  ) to keep our QA server upto date with our live AS server as it seems pointless rebuilding the cubes on both (takes over 2 hours) and is quicker to do backup and restore. Its well worth taking nightly backups of your cubes anyway - AS is no different from SQL server - you can never have to many backups. What you want in a DR situation is lots of optionsHTHJasper Smith |
 |
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2002-05-13 : 00:12:14
|
| well thanks so much for advice. will that be goood in case of dimension and mining models and other stuff.. and can i uploaded them on internet so that i can downlaod them and rebuild them on another server... provided that data structure is there on the server....thanks in advance |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-13 : 13:42:12
|
| I see no reason why you can't upload the archive file to the internet and download it a site where the structures exist.I'm not sure about data mining as its not something we use but if it simply works on existing OLAP data and you can save mining definitions or whatever they are as some form of ile then I'd guess you would be able to use them too.Good LuckCheersJasper Smith |
|
|
|
|
|
|
cubes can be portabel ???