Database Builds

Article

You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.

2019-12-13

From Source Control to Database using SQL Compare Command Line

by Additional Articles

Redgate

Article

Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.

2019-12-12

Discuss

Resolving Cross Database Dependencies in SQL Change Automation using Local Databases or Clones

by Additional Articles

Redgate

Database Builds

Article

Kathi Kellenberger explains how to avoid build problems, when working with set of inter-dependent databases, by restoring or provisioning copies of all required databases to the development, build, or test instance.

2019-09-09

Over-thinking Database Build Scripts

by Phil Factor

SQLServerCentral

Database Builds

Editorial

With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1 (1)

You rated this post out of 5. Change rating

2019-06-29

322 reads

Discuss

Static Data and Database Builds

by Tony Davis

SQLServerCentral

Database Builds

DatabaseWeekly

Often, we can't build a fully functional SQL Server database just from the DDL code. Most databases also require what is often referred to as 'static', or 'reference' data, which will include such things as error messages, names of geographical locations, currency names or tax information. What's the best way to handle such data?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-05-31

Better Ways to Build a Database

by Additional Articles

SimpleTalk

Database Builds

Article

The purpose of a database build is simple: prove that what you have in version control can successfully create a working database, and yet many teams struggle with unreliable and untested database build processes that slow down deployments and prevent the delivery of new functionality. Grant Fritchey explains how to achieve an automated and reliable database build that is only as complex as the database system it needs to create.

2016-03-22

5,439 reads

Database Builds

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

From Source Control to Database using SQL Compare Command Line

Resolving Cross Database Dependencies in SQL Change Automation using Local Databases or Clones

Over-thinking Database Build Scripts

Static Data and Database Builds

Better Ways to Build a Database

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

Flying Halfway Around the World to Australia

Dealing with Change – Two Resources

Forums

SSIS Execution Error

Pivot query

Table with FK(s) to other columns within the table

Question of the Day

Using Table Hints in a Query