Share via

Specifying the Installation Target

  • Article

The Analysis Services Deployment Wizard reads the installation target information from the <project name>.deploymenttargets file. SQL Server Data Tools (SSDT) creates this file when you build the Microsoft SQL Server Analysis Services project. SQL Server Data Tools (SSDT) uses the database and server specified on the Deployment page of the <project name> Properties Pages dialog box to create the <project name>.targets file.

Modifying the Installation Target for Deployment

In some situations, you may need to deploy an Analysis Services project to a database or Analysis Services instance that is different than the one specified on the Deployment page. For example, you may want to deploy the project to a server for testing before deployment, and then deploy it to a production server after testing is finished. You may also want to deploy a completed and tested project to multiple production servers in a Network Load Balancing cluster, or to a staging server and a production server.

To deploy an Analysis Services project to a different database or Analysis Services instance, you can change the installation target in the input file by using one of the methods described in the following procedure.

To change the installation target after the input files have been generated

  • Run the Analysis Services Deployment Wizard interactively. On the Installation Target page, specify a new destination for the Analysis Services instance and database.

    -or-

  • Run the Analysis Services Deployment Wizard at the command prompt and set the wizard to run in answer file mode. For more information about answer file mode, see Running the Analysis Services Deployment Wizard.

    -or-

  • Modify the <project name>.deploymenttargets file by using any text editor.

See Also

Specifying Partition and Role Deployment Options
Specifying Configuration Settings for Solution Deployment
Specifying Processing Options