Database Builds

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

  • 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

Over-thinking Database Build Scripts

  • 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)

2019-06-29

295 reads

Static Data and 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?

2019-05-31

Better Ways to Build a Database

  • 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

Blogs

Transforming JSON data with the help of Azure Data Factory - Part 4 - Passing Arrays around

By

(2020-May-24) It has never been my plan to write a series of articles about how...

3D Printing Ear Savers

By

On April 5th, I started printing ear savers for healthcare workers. I started with...

Updated Default Settings for Azure SQL Managed Instance Databases

By

A common saying about Azure is that it is always changing. This is a...

Read the latest Blogs

Forums

Are there application developers in here? Where are you doing your SQL?

By bbsimonbb

Hi, Are there app developers in this forum? Where does your app's SQL live?...

Building Better Software for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Better Software for Everyone

Rounding and Sums

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Rounding and Sums

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers