source control

Dedicated Link Source Control Repository

This is the fifth part of an extensive article dedicated to database versioning. Before you proceed with it, we suggest that you read the previous parts:

(more…)

Database Version Control Using Source Control for SQL Server

There are many solutions for version-controlling databases. We are going to review one of them, namely Source Control which comes in the SQL Tools pack. As an example, we will use the JobEmplDB database for a recruitment service:

(more…)

Creating a TFVC Repository in Azure DevOps and Linking It to Source Control

The article provides a complete walkthrough to help you create a TFVC repository in Azure DevOps and link your database to the repository via the Source Control tool by dbForge. You will be able to version control your database and keep a history of changes.

(more…)

How to Set Up Version Control of Your SQL Server Database from Scratch

Version-controlling SQL Server databases in GitHub has never been easier with Devart solutions. You can commit and revert changes, view and resolve conflicts, track changes and link static data with convenience. And such tools as dbForge Source Control will help you easily and effectively manage your GitHub repository.

But now let’s go back and see where it all begins. Let’s see how to create a new repo on GitHub and then clone it to your local computer.

(more…)

Database Versioning with Examples

To properly manage the database development process, stay informed of the changes delivered by other developers, and avoid conflicts or missing data in the database, one needs database versioning. This allows you to reconstruct any version of the database, view the history of changes, and ensure smooth database delivery.

(more…)

Version Control System – Version Control with Git

The article deals with the basics of versioning SQL Server databases and goes into the basics of working with the Git version control system.

(more…)

Shared vs Dedicated Development Models: Key Differences

Developing databases in a secure and efficient way is very important for each database developer in the team. To maintain and keep an eye on any changes made to the databases, resolve conflicts, and roll back to the earlier versions if needed, the good solution will be to use a version-controlling tool. It can also help developers to compare versions and identify what changes have been made and who is the author.

(more…)

Azure Data Studio vs SSMS: Who’s the Winner?

For 15 years, SSMS has held the title of the top SQL Server database tool. That’s no easy feat, especially in the software world, where things can change faster than you say “blueberry pie.” But then a contender emerged, developed and released by the same Microsoft folks in 2018. It was Azure Data Studio – obviously less mature, weaker in terms of database administration, yet very promising and eager to win its audience. And today, we’re going to put them face to face and find out who’s better.

(more…)

Continuous Delivery of Database Changes to SQL Server When Working Remotely

In the process of software product development that involves a database, one of the key points is the possibility of continuous delivery of changes from the development environment to the production environment.

(more…)

Working with Multiple Branches in Source Control

With the help of dbForge Source Control tool that comes as an add-in for Microsoft SQL Server Management Studio and is included in dbForge Studio for SQL Server, you can quickly connect databases you’re working on to your version control system of choice and easily switch between different branches.

(more…)