SQL Change Automation maintains two databases:
The Target Connection string can be set by clicking the Edit button within the Debug tab of the project designer.
This will display the connection dialog, from which you can either browse to the desired server or enter the connection details:
Build your solution to update the connection within the SQL Change Automation tool-window.
By default, the Shadow database will be deployed to the same SQL Server instance that you've chosen for your development database.
If you would prefer not to deploy the Shadow database to this instance, check the following option on the Debug tab: Always use default connection string for Shadow database.
This will cause the Shadow database to be deployed to the connection displayed in the Default Connection String box, typically (localdb)\ProjectsV13.
Build the solution to update the Shadow connection within the SQL Change Automation tool-window.
You may configure the Shadow database to be created on a specific SQL Server instance by adjusting the default connection string in the project.
Firstly, under the Target Connection String, click Edit to display the connection dialog. Specify the SQL Server instance that you would like to deploy the Shadow database to.
Then, click Set As Default to set this connection as the Default Connection String.
The connection string will then be displayed in the Default Connection String text box.
The Default Connection String is a setting that is included in your .sqlproj file. This means that this setting will be shared with others when you check the project into source control, so the connection details you provide should be valid for everyone in your team.
Click Edit... once again in order to set the Target Connection String back to its previous setting.
Ensure that the following option is checked: Always use default connection string for Shadow database.
Build the solution to update the connection details within the SQL Change Automation tool-window.
When you next Import changes into your project, the Shadow database will be deployed to the specified server. Feel free to drop any shadow databases created by SQL Change Automation on any of your other servers (this can be identified by the _SHADOW database name suffix).