Recently, one of our customers asked us how to synchronize large databases if the size of the generated synchronization script couldn’t be opened by dbForge Data Compare for SQL Server for editing. He tried to synchronize his large database, but the generated synchronization script (Table Data Update Script of all tables) was of a great size, so the program could not open it and recommended direct execution. However, the user wanted to review the script and edit it before execution.

Such cases are quite common, so here is the solution we recommend.
If you have a big database, synchronize it in three stages:

(more…)

After analyzing our users’ feedback on the first release of dbForge Schema Compare for SQL Server. We decided to change our roadmap for this product and to release version 1.1 of the product before adding new major features.

So what new features will this version include?

(more…)

Introduction

Devart Company has launched a new product line for working with SQL Server databases. Recently we have released a beta version of the first product in this dbForge for SQL Server product line – dbForge Data Compare for SQL Server. It is a tool for data comparison and synchronization.

Product’s key features

Nowadays there is a wide variety of data comparison and synchronization tools. It takes time and efforts to make a reasonable choice. We have analyzed a number of such products and found that Data Compare for SQL Server stands out against competitors thanks to a number of key features.

In this article, I am going to tell what exactly distinguishes Data Compare for SQL Server from dozens of similar tools. The key features list of Data Compare for SQL Server includes the following:

(more…)

How to compare and synchronize MySQL views? Recently we discovered some tricks in schema synchronization process of MySQL databases. It’s about how MySQL creates views and tables with foreign keys. I’m going to explain them and give workarounds for dbForge Studio for MySQL users.

(more…)