SQL Change Automation 4

SQL Change Automation project user settings

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.

SettingRequired?Description
TargetConnectionStringBased on your development sourceThe connection string for the development database to use in your development environment.
ShadowConnectionStringBased on your development sourceThe 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>

Didn't find what you were looking for?