database delivery

External Article

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

SQL Prompt Tips–Using $surroundtext$ in a Snippet

By

A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

SQL Server Quickie #46 – SQL Server on Linux

By

Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Giving a Security Webinar this Wednesday

By

If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...

Read the latest Blogs

Forums

sp_dropserver - Bug/behavior change - Leaves transaction open after TRY...CATCH

By Ronzo

Verified on latest CU 10 for SQL 2022. Confirmed works correctly on SQL 2019...

broker error

By joey

Hello, I install a broker under sql server 2016 and I have a message...

Suggestion on HA DR solution for transactional replication published database

By Saran

Hi All, I am planning for HA DR solution for transactional replication published database....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers