sql server

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

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

Devart sponsored SQLSaturday 857 in Kyiv, Ukraine

SQLSaturday is one of the largest free-to-attend IT events in Ukraine, and Devart was its Gold Sponsor this time.

We had a lot of new product to show, gave a lot of interesting talks and had many interesting productive conversations. (more…)

Automatic Schema Comparison Log Delivery via Email

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

How to quickly generate documentation for your SQL Server database

In this blog post, we will learn how to quickly create a comprehensive documentation of an SQL Server database using SQL documentation tool from Devart. (more…)

SQL Server 2016 Stretch Database

On June 1, SQL Server 2016 was released. It brought a large number of novelties into normal development, including the long-announced Stretch Database technology that allows migrating data from SQL Server dynamically to Azure. (more…)