sql server

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

How to generate and use CRUD stored procedures in SQL Server

Most database systems operate on the basis of 4 simplest data manipulation operations that are called by the acronym CRUD. This acronym stands for Create, Read, Update, and Delete.

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

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

Devart sponsored SQLSaturday Kharkiv 2019

For the past decade, Devart has been actively supporting SQL Saturday events including this year’s conference in Kharkiv, Ukraine. As usual, Devart was a Gold Sponsor of the event which was held on September 28 at Fabrika space.

(more…)

Devart sponsored SQL Saturday Lviv 2019

We are delighted to inform you that Devart was a Gold sponsor of the SQL Saturday Lviv 2019 event that took place on September 21 in Lviv, Ukraine. Providing support and sponsorship for both, local user group meetups, and global industry-level events is an endeavor that Devart strives to stick to and keeps developing.

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

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