June 16, 2014 at 12:09 pm
Hello,
When I R-Click on a SSAS DB, and select [script database as CREATE TO], does that script contain everything in that DB? My question is, if I run that full script will it create that exact DB (cubes, measures, partitions, etc)?
Any help would be appreciated
SQL-TG
The are no problems, only solutions. --John Lennon
June 16, 2014 at 12:26 pm
Yep, everything, to the extent that if you try and run it ont he same server/instance without changing some names, it'll fail (because these already exist).
Steve.
June 16, 2014 at 12:30 pm
Thanks!
The are no problems, only solutions. --John Lennon
June 16, 2014 at 12:51 pm
SQLTougherGuy (6/16/2014)
Hello,When I R-Click on a SSAS DB, and select [script database as CREATE TO], does that script contain everything in that DB? My question is, if I run that full script will it create that exact DB (cubes, measures, partitions, etc)?
Any help would be appreciated
SQL-TG
It will also create the exact same security. So if you are deploying to another environment with other security needs, you might to take that into account.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply