SQL Change Automation project user settings
Published 20 August 2019
The SQL Change Automation user settings file contains settings specific to your local environment which shouldn't be committed to version control.
These settings only apply when developing database changes in SSMS or Visual Studio and should not affect deployment.
| Setting | Required? | Description |
|---|---|---|
| TargetConnectionString | Based on your development source | The connection string for the development database to use in your development environment. |
| ShadowConnectionString | Based on your development source | The connection string for the shadow database to use in your development environment. If this is not set, then the shadow database connection string will be derived from the development database connection string. |
Full sample file:
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
<TargetConnectionString>Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=True</TargetConnectionString>
<ShadowConnectionString>Data Source=(local);Initial Catalog=AdventureWorks_some.user_SHADOW;Integrated Security=True</ShadowConnectionString>
</PropertyGroup>
</Project>
