synchronize database

How to Synchronize a Table in SQL Server

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

Database synchronization is an everyday necessity. You need it regularly when you have several similar databases that serve the same “user.”

(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 run automatically on a schedule and with no need for outside intervention.

(more…)

Loading Oracle LOB Data – Code Samples

Recently we were working over the release of the version 2.0 of  dbForge Data Compare for Oracle. One of the main features added to the new version was synchronization of the LOB data. When we developed the first release of the product we postponed this feature because of challenges of synchronizing LOB data. These challenges caused by nature of data stored in BLOB or CLOB columns. It’s large and simply does not fit into SQL script. But we’ve found the solution.

(more…)

Oracle DBMS_COMPARISON package overview

During replicating data in one or another way, it happens that synchronized objects may differ. This situation may take place in the following cases:

  • If changes made in one of copied databases were not captured
  • The changes were captured but not forwarded
  • The changed were forwarded but not applied due to some reasons (more…)

Quick start in database development with Sakila database project

The Sakila project was designed to demonstrate all cutting-edge capabilities of dbForge Studio for MySQL such as Database Projects, Database Diagram, Data Reports, Pivot Grid, Visual Query Builder, Code Refactoring, Database Comparison and Synchronization, and also to let a user get acquainted with the mentioned functionality quickly and easily with the help of the prepared examples.

(more…)

Synchronizing SQL data between a company database and a data warehouse

Recently we’ve received a question from one of our customers asking how to synchronize data between companies servers and a data warehouse server. Let’s see how easy it can be done with the help of  dbForge Data Compare for SQL Server, a professional tool for SQL data comparison and synchronization. (more…)

Data Comparison Methods and Techniques

Data comparison is a difficult and resource-intensive process. In the article, we are going to explore algorithms, advantages, and disadvantages of specific data comparison, as well as describe how to compare data between two MySQL databases with dbForge Studio for MySQL.

(more…)

Backup Comparison and Database Versioning Added in Schema Compare for SQL Server


Schema Compare for SQL Server 2.00 compares schema snapshots, database backups, and database changes in version control systems to accelerate the work of advanced database developers.

Devart today announced the public availability of  Schema Compare for SQL Server 2.00 that delivers new capabilities to help customers more effectively compare databases and more quickly migrate schema changes across different SQL Server versions.

Featuring new functionality, the tool is better equipped to span a full spectrum of database comparison and synchronization tasks and allows completing them at a professional level.

(more…)

How to Migrate Databases of Different SQL Server Versions

Need to move databases from SQL Server 2000 to SQL Server 2005 – 2008 or vice versa?

(more…)

Would you like to change data types or other attributes for multi tables in one shot?

Recently we’ve got a letter from a customer asking how to alter all float datatype to double datatype in one “Find and Replace all” shot. Good news! dbForge Studio can do this.  Let’s see how Find and Replace functionality,  Schema Compare tool,  and a database project of dbForge Studio will do their best to change the required properties at a heat.
(more…)