Deploy Model Solutions Using XMLA
Applies To: SQL Server 2016
In SQL Server Management Studio, the CREATE To option of the Script Database As command creates an XML script of an entire Microsoft SQL Server Analysis Services database or one of its constituent objects. The resulting script can then be run on another computer to recreate the schema (metadata) of the Analysis Services database. The script generates the entire database, and there is no mechanism for incrementally updating already deployed objects when using the script. After running the script and deploying the database, the newly created database must be processed before users can browse it.
For more information about the Script Database As command, see Document and Script an Analysis Services Database.
When using the Script Database As command, you cannot modify specific properties (such as the database name, data source connection strings, and security settings) of the database objects. These properties must either be manually modified in the script after the script has been generated or modified in the deployed database after running the script.