Creating a New Database in MySQL: Tutorial with Examples

The article provides a detailed overview of how to create a database in MySQL using different methods and tools (including the Command Line, Workbench, and dbForge Studio for MySQL).

Read the rest of this entry »

How to Write Complex Queries in SQL Server

One of the regular jobs performed by a database administrator and developer is creating and executing queries of higher complexity to resolve complicated tasks. This requires extra caution and seriousness because any inaccuracies in the code can result in undesirable bugs and application downtime.

Read the rest of this entry »

SQL INSERT INTO Statement – Overview with Examples

The article presents a step-by-step guide to SQL INSERT INTO statement. You will learn the basic principles underlying this command and see how to implement this statement visually using dbForge Query Builder.

Read the rest of this entry »

How to Speed Up Populating Tables with a Large Amount of Random Data for SQL Server Performance Testing

Very often, developers and QAs need to load a large amount of test data to assess the speed of populating the database with generated data and analyze how the performance changes with the database growth.

Read the rest of this entry »

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 functionality 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 Schema Comparison

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 »