COPA Database Project Template

Custom SQL Server database project template for Visual Studio 2015, 2017 & 2019.

Adds AssemblyInfo.cs file containing all three version attributes to aid in schema versioning.

Includes three standard publish profiles to be setup for development, test & production databases. These are useful for producing point-in-time what-if deployment scripts so you are fully aware of the changes that will be made upon publishing.

Publish profiles are used to ensure that only the types of changes you explicitly set will be made upon publishing the DacPac.

The publish profiles are setup to limit the allowed changes to these objects:

• Extended properties
• CLR user-defined types
• Scalar-valued functions
• Stored procedures
• Table-valued functions
• Tables
• User-defined data types
• User-defined table types
• Views

Note: it is important that these profiles be kept current with each new release of the data tools by ensuring that any new options are added to these publish profiles with the appropriate values, otherwise the option's default value will be used and could very well be inappropriate or even violate release policies.