Database Deployment

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

• by Additional Articles

• Redgate

• Database Builds
• Database Deployment
• SQL Change Automation
• SQL Compare

• 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

• Database Builds
• Database Deployment
• SQL Compare

• 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

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

• by Additional Articles

• Redgate

• Database Deployment
• SQL Change Automation
• SQL Compare

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

• Discuss

Building an Automated Database Deployment Pipeline

• by Additional Articles

• SQL Server Magazine

• Database Deployment

• Article

Data and databases are historically ignored or given a low priority within the processes of ALM and DevOps. This situation needs to change and the primary point of the changes is within the database professional part of the team.

2014-11-25

7,702 reads

Common database deployment blockers and Continuous Delivery headaches

• by Additional Articles

• SimpleTalk

• Database Deployment

• Article

Deployability is now a first class concern for databases, so why isn’t it as easy as it should be? Matthew Skelton explores seven of the most common challenges which will bring your database deployments to their knees.

2014-08-18

10,398 reads

Avoiding Database Deployment Disasters – 7 Tips

• by Additional Articles

• SimpleTalk

• Database Deployment

• Article

Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a database live to production, in a development environment that is in the early stages of getting the database code “house in order".

2014-07-29

10,764 reads

Same tune, different song

• by Phil Factor

• SQLServerCentral.com

• Database Deployment

• Article

It's not new and I'm already doing it. Phil Factor, a.k.a. Methuselah, on Agile, DevOps and Continuous Delivery.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

You rated this post out of 5. Change rating

2014-06-16

110 reads

• Discuss

Rapid SQL Server Database Deployment

• by Additional Articles

• SimpleTalk

• Database Deployment

• Article

With the right tools, it is possible to rapidly deploy upgraded databases. By deploying early in development, it's easier to iron out any potential problems that the new deployment could cause in production long before it's time to actually release the software.

2014-03-11

4,431 reads

Developing for Delivery, a Practical Example

• by Additional Articles

• SimpleTalk

• Database Deployment

• Article

Richard Morris interviewed Michael Stoop, a database developer at Calvi, Europe's leading provider of Telecom Invoice Management software. The discussion focused on how Calvi transformed their database delivery process to accommodate massive database growth, statutory regulations, and developments in their application. Here's their story.

2013-09-30

3,001 reads

Automating SQL Server Database Deployments: Scripting Details

• by Additional Articles

• SimpleTalk

• Database Deployment

• Article

To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted a solution and comes up with several practical tips for getting the most out of any automated database deployment framework.

2013-06-28

4,648 reads