Understanding Deployment Scripts
The previous section described how you could use the Deployment Wizard to generate an XMLA file for deploying your database. You can also use SQL Server Management Studio to create XMLA deployment scripts.
Deployment scripts can be extremely useful in organizations that have a separation of duties between development and production support. In many organizations, developers are not allowed to deploy their own code into production. In these situations, it is necessary to create script files that can be executed by production support administrators. The following exercise examines how scripts can be created using SQL Server Management Studio.
Create a deployment script
On the Microsoft Windows task bar, click Start, ...
Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
