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?

dbforge, dbForge Studio for SQL Server, sql server / May 7th, 2021

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:

• Part I: Version Control with Git
• Part II: Database Versioning with Examples
• Parts III & IV: Database Version Control Using Source Control for SQL Server

database versioning, dedicated database development model, shared database development model, source control, version control, versioning / May 6th, 2021

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:

reverse engineering, source control, version control / May 5th, 2021

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.

azure devops, source control, tfs, tfvc / April 29th, 2021

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 »

odbc, what's new odbc drivers / April 27th, 2021

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.

object filter, schema compare, sql server / April 22nd, 2021

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

dbforge, dbforge transaction log, sql rollback transaction, sql server transactions / April 21st, 2021

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.

dbforge, dbForge DevOps Automation, sql server / April 20th, 2021

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.

dbforge, dbForge Source Control, source control, sql server, version control / April 16th, 2021

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.

dbForge Studio for MySQL, mysql inner join, mysql joins, mysql outer join / April 13th, 2021