Database Builds

External Article

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

SQLServerCentral Editorial

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)

You rated this post out of 5. Change rating

2019-06-29

337 reads

Technical Article

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?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-05-31

External Article

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

T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement

By

It’s that time of the month again, and once again, I’m late and I’m...

The Book of Redgate: What Our Customers Say

By

This is from 2010, but I loved that people felt this way about Redgate...

Export a Power BI Report that cannot be Downloaded

By

Yes, you’re reading that right, we’re going to download a report that cannot be...

Read the latest Blogs

Forums

The Cosmetics Testing Laboratory is called FARE LABS Pvt. Ltd.

By farelabs

Because we are NABL Accredited Laboratories, our personal care and cosmetics research center provides...

fast farward curson vs while loop on @table

By rajemessage 14195

hi, need to known weather fast farwand cursor is faster than a while loop...

Economics of AI: What is the Real Cost to Profit?

By dbakevlar

Comments posted to this topic are about the item Economics of AI: What is...

Visit the forum

Question of the Day

Getting the Indexed Columns

I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned? 

SELECT   
    INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail')

See possible answers