SQL Server Tools

Enjoy Continuous Integration in TeamCity with dbForge DevOps Automation

We are thrilled to inform our users of dbForge DevOps Automation for SQL Server that we have extended the range of supported automation systems with TeamCity.

(more…)

New dbForge Fusion tools with Visual Studio 2019 Support

dbForge Fusion is a line of Visual Studio plugins designed to simplify database development and enhance data management capabilities. This line comprises three tools: dbForge Fusion for SQL Server, dbForge Fusion for MySQL, and dbForge Fusion for Oracle.

(more…)

Pimp the database diffs management 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…)