database delivery

How to Automatically Create and Refresh Development and Test Databases

  • Article

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database is big. Phil illustrates a solution by taking a set of Redgate tools to show how they can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers with the database build, taking care to save any DDL changes to the existing copies of the database.

2017-08-08

5,020 reads

Blogs

Daily Coping 27 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 26 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure SQL Database – Greatest and Least TSQL

By

Being in the cloud does have many benefits, from lower administration to fast scaling...

Read the latest Blogs

Forums

RegisterAllProvidersIP = 0 and timeout in failover

By abdalah.mehdoini

Good morning all , I have an alwayson instance with a multisubnet listener I...

Tempdb increasing crazily

By 892717952

These days, the Tempdb of my one's SQL server increases crazily, sometimes only abount...

Bad career advice from a 14 year old

By Kathi Kellenberger

Comments posted to this topic are about the item Bad career advice from a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers