Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Understanding the Input Files Used to Create the Deployment Script

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

When you build a Microsoft SQL Server Analysis Services project, SQL Server Data Tools (SSDT) generates XML files for the project. SQL Server Data Tools (SSDT) puts these XML files in the Output folder of the Analysis Services project. By default output is out in the \Bin folder. The following table lists the XML files that SQL Server Data Tools (SSDT) creates.

XMLA file


<project name>.asdatabase

Contains the declarative definitions for all the Analysis Services objects in the project.

<project name>.deploymenttargets

Contains the name of the Analysis Services instance and database in which the Analysis Services objects will be created.

<project name>.configsettings

Contains environment specific settings, such as data source connection information and object storage locations. Settings in this file override settings in the <project name>.asdatabase file.

<project name>.deploymentoptions

Contains deployment options, such as whether deployment is transactional and whether deployed objects should be processed after deployment.

Note Note

SQL Server Data Tools (SSDT) never stores passwords in its project files.

Modifying the values in the input files, or the values retrieved from the input files, makes it possible to change the deployment destination, the configuration settings, and deployment options without editing the whole <project name>.asdatabase file (or a whole XMLA script file if you generate a script from an existing Analysis Services database). Being able to modify individual files lets you easily create different deployment scripts for different purposes.

The following topics explain how to modify values in the various input files:

Community Additions

© 2015 Microsoft