source control

Using SQL Source Control projects in Azure Data Studio

• by Additional Articles

• Redgate

• source control
• SQL Source Control

• Article

David Atkinson describes how developers who were previously writing and managing SQL source code in SSMS can make a smooth transition to Azure Data Studio.

2020-07-09

Custom Deployments from Source Control using SQL Compare Command line

• by Additional Articles

• Redgate

• source control
• SQL Compare

• Article

Giorgi Abashidze explains how his team use a 2-phase deployment process with SQL Compare Command line, and some SQL Synonyms, to automate custom deployments for each of their customers, while only needing to maintain one branch per release in source control.

2020-02-05

From Source Control to Database using SQL Compare Command Line

• by Additional Articles

• Redgate

• source control
• 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-06

• Discuss

Core Database Source Control Concepts

• by Additional Articles

• SimpleTalk

• source control

• Article

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.

2017-03-21

5,188 reads

Write Cleaner T-SQL Using Version Control

• by Ed Elliott

• SQLServerCentral.com

• source control

• Article

If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to write better, cleaner, more readable code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1.86 (29)

Log in or register to rate

You rated this post out of 5. Change rating

2015-10-05

6,104 reads

• Discuss

Why Put Your Database into Source Control?

• by Additional Articles

• SimpleTalk

• source control

• Article

Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong.

2014-07-25

12,084 reads

Version Control as a Cloud Service

• by Additional Articles

• SimpleTalk

• source control

• Article

Robert Sheldon wonders if cloud-based version control still too risky for a service that must be secure, and risk-free?

2014-07-15

11,224 reads

Finding SQL Server objects that reference invalid objects

• by Additional Articles

• MSSQLTips.com

• source control

• Article

Since many environments haven't committed to using a source control system, identifying mismatched objects can offer a challenge. Tim Smith offers a solution.

2014-07-01

3,659 reads

Branching and Merging: Ten Pretty-Good Practices

• by Additional Articles

• SimpleTalk

• source control

• Article

After experiencing 'merge misery' personally, Konrad Lukasik came up with 10 well-tested ways of making branches and merges a stress-free part of application development.

2014-05-29

7,273 reads

Database Source Control- The Crib Sheet

• by Additional Articles

• SimpleTalk

• source control

• Article

As part of our long-running Cribsheet series, we asked William to come up with a brief summary of what was involved in bringing database development work under source control. What are the advantages it brings, and are there disadvantages?

2010-07-30

3,656 reads