SQL Server Tools

Pimp the database differences with new dbForge Studio for SQL Server v5.8

We are glad to announce that we have just rolled out the new dbForge Studio for SQL Server, v5.8. This version features massive improvements of data and schema comparison features, including redesigned diffs presentation, and provides as convenient and effective management and deployment of data and schema diffs as never before. (more…)

Code Completion and SQL Code Navigation improved in SQL Complete v6.2

The dbForge team is excited to announce the release of a greatly enhanced SQL Complete v6.2. Being the flagman solution of the Devart company, SQL Complete is aimed at building consistency and quality into your code. This add-in for SSMS and VS will facilitate your database development, minimize downtime and help avoid performance issues.

The release addresses a number of major features and improvements.

(more…)

Performing audit changes and rollback transactions is now simpler than ever

There is an old joke that goes something like this: “There are two types of system administrators – those who don’t backup their data yet, and those who already do.” (more…)

A New Look of Differences in Compare Bundle!

We are thrilled to announce a huge update of our SQL Server comparison tool pack,  dbForge Compare Bundle for SQL Server.  The new versions of dbForge Schema Compare for SQL Server and dbForge Data Compare for SQL Server include a number of new features that deliver extra convenience to working with data and schema differences. In addition, the core features of the tools have been greatly redesigned and improved to make your experience with the tools as good as it gets. (more…)

Store and Share Static Data in Updated Source Control!

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…)

How to Set Up Source Control: a Short Guide for Evaluators

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…)

Linking and Comparing SQL Server and PostgreSQL Databases

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…)

How to automatically synchronize data in two SQL Server databases on a schedule

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…)

How To Generate and Fill a Doubly Linked List Table

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…)

Welcome to the Future of SQL Database Development!

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…)