data warehouse

Synchronizing data between a company database and a data warehouse

Posted by on April 15th, 2010

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: