Synchronizing data between a company database and a data warehouse
Thursday, April 15th, 2010Recently 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: