DBeaver vs HeidiSQL vs dbForge Studio: Comparing Open-Source and Paid SQL Server Tools

If a company has to choose between a free database tool and a paid one, and both of them deliver the same features and performance, it is natural that the paid one doesn’t stand a chance. But what if the free tool doesn’t contain all the necessary tools for the workflow? What if it has limitations that prevent the employees from becoming more productive? And if it turns out that their work requires either 7 separate, perhaps even hardly compatible free tools, wouldn’t it be more effective to pay for just one tool that would have it all in place?

Read the rest of this entry »

Dedicated Link Source Control Repository

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:

Read the rest of this entry »

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.

Read the rest of this entry »

New Versions of ODBC Drivers for Salesforce, Dynamics 365, and Zoho CRM

ODBC drivers for Salesforce, Dynamics 365, and Zoho CRM

We are glad to announce new versions of the ODBC drivers for Salesforce, Dynamics 365, and Zoho CRM. The most notable updates include OAuth 2.0 authentication for Dynamics 365 and Salesforce, and SOQL queries for Salesforce.

Read the rest of this entry »

Using Object Filters to Adjust dbForge Schema Comparison Process

In this article, you will learn how to apply object filters within dbForge Schema Compare for SQL Server to be able to adjust the schema comparison and synchronization process to your needs by excluding and including the necessary objects and object types.

Read the rest of this entry »

How to Rollback Committed Transactions on MS SQL Server

The MS SQL Server database management system suggests that all changes are carried out via transactions. Transactions are created to ensure the ACID requirements:

Read the rest of this entry »

How to Download and Install dbForge DevOps Automation PowerShell for SQL Server

dbForge DevOps Automation PowerShell for SQL Server

dbForge DevOps Automation helps automate SQL Server database development, testing, and deployment. It was designed to minimize deployment risks and speed up the release cycle, making the overall workflow safe and consistent.

Read the rest of this entry »

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

How to Set Up Version Control of Your SQL Server Database

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.

Read the rest of this entry »

MySQL JOINs Tutorial with Examples

The article presents a detailed tutorial on MySQL JOINs. In it, you will learn about different types of JOINS that are supported in MySQL, their syntax, and how to use them.

Read the rest of this entry »