April, 2010

Devart announced the release of a new version of the professional tool for SQL server data comparison and synchronization – dbForge Data Compare 2.00. Committed to support the needs of database-dealing professionals, Devart now delivers a performance-leading SQL comparison tool that incorporates three times faster data comparison and synchronization, the smallest price and greater satisfaction than all other data comparison tools offer.

Incorporating these three components, dbForge Data Compare 2.00 guarantees greater satisfaction and smother database-dealing experience for any SQL comparison and synchronization goals.

The highlights of dbForge Data Compare 2.00 include:

(more…)

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 data comparison and synchronization.

What we have:

We have two companies ( they use ERP software), each having their own SQL Server database with one table. The companies tables with their customers’ data are saved in the data warehouse as follows:

• The SQL table for company1 is Company1$Customer.
• The SQL table for company2 is Company2$Customer.

What we need:

We need to create a data warehouse with all information stored in one set of SQL tables. For example, the created data warehouse should contain a Customer table that contains all records of Company1$Customer and Company2$Customer.  This table should contain an extra field with a company name to make the records unique. We need to synchronize only changed records.

How to complete the task:

(more…)