SQL create database and SQL Server builds articles

A collection of articles covering SQL create database and SQL Server build topics

Build automation

• How to automatically build a database from SQL Server source control

Continuous integration

• SQL Server database continuous integration workflow BUILD step – Building a SQL database from a source control repository

Object customization

• How to customize the SQL Server database objects to be deployed in a database build process
• How to re-order scripts to avoid dependency-based errors

Packages and deployment

• How to make complex SQL database deployments easier
• How to package database scripts into C# projects and executable installers

Source control

• How to build a SQL Server database from source control
• How to build a SQL database from source control without dependency problems
• How to create a SQL build script from the source control repository
• How to deploy static data from SQL source control to database
• How to work with SQL database source control labels

Script consolidation

• How to consolidate multiple SQL scripts into a single SQL script