SQL Server Tools

We are pleased to announce the release of the new version of our MS SSMS add-in for easy tracking and deployment of changes, dbForge Source Control for SQL Server, v2.0.  The updated version allows version-controlling static data, includes support for the latest SQL Server and Microsoft SQL Server Management Studio, and more. (more…)

dbForge Source Control is a powerful SSMS add-in for managing SQL Server database changes in version control systems. The tool allows version-controlling schemas and reference data, rolling back changes, and maintaining the referential integrity of your SQL databases. This solution can also solve other database challenges, including deployment without losing data. dbForge Source Control can link your databases to all common source control systems, including SVN, TFVC, Git, Perforce, Mercurial, and SourceGear Vault. By any definition, dbForge Source Control delivers smooth and clear workflow in a familiar interface.

(more…)

In this article, we will describe how to link a PostgreSQL Database to SQL Server, compare and deploy the PostgreSQL data against SQL Server with the help of dbForge Studio for SQL Server.

The workaround for the task suggested in this article consists of three major steps: (more…)

Data in SQL databases often needs to be synchronized in real time – this can be achieved by checking one database for updates and then applying them to another database. In this case, the process of change detection and synchronization should be ran automatically on a schedule and with no need for outside intervention. (more…)

Introduction

In this article, we’ll learn how to fill a doubly linked list table with SQL test data. In such tables, there can be various independent chains unified by unique tags into groups. (more…)

We are thrilled to announce the most notable addition to our dbForge for SQL Server product line in years, dbForge DevOps Automation for SQL Server. (more…)

dbForge SQL Complete includes the whole range of options that provide possibilities for powerful optimization and great performance increase. Execution history is an important part of this list. It is included into the Standard and Express edition package. The feature stores basic information about executed SQL statements for a certain period. (more…)

dbForge SQL Complete is a multifunctional add-in for SSMS that simplifies the development and administration processes greatly. Our users have an opportunity to use this tool in two editions: Standard and Express. The availability of a free Express edition appears after the 30-day trial Standard. Let’s see what the user has to do to start using dbForge SQL Complete Express.

(more…)

Please welcome a new version of dbForge SQL Complete 6.1 with support for Visual Studio 2019, new command line interface and tunable Summary Panel. (more…)

In this article, we will show how to set up automatic email delivery of the log file when a comparison of multiple SQL schemas fails. The task will be completed by means of dbForge Studio for SQL Server. Specifically, we will use its command-line functionality, allowing to perform routine tasks in both, command prompt and PowerShell. In this article, we will focus on the command prompt.

(more…)