Sql Server:consolidate data from different databases to one single database

[Rattlesnake]

Hi,

I have an application that has Sql Server 2000 as the database.

This application is used in different Offices of our comapny around the world with each Office having there own independent Sql Database.

 

For global reporting purposes I would like to create an instance of the Database that would receive all the transactional information from all the databases from all the companies.

 

 

This would give us a repository for generating global reports.

 

I have taken a look at Replication in Sql Server , but it seems that it is used for synchronizing different databases. I donot want synchronisation . The independent databases of all the offices will continue to work the way they are.

 

All I want is that all records in the database should be sent to one centralised database.

 

How can I implement this ??

 

Thanks

[PlausiblyDamp]

SQL Server replication can definately work for you in this situation, not all types of replication are designed to keep copies in sync.

Make each of the office servers a publisher of the database (or relevant parts of it) and make the central server a subscriber. This way all changes will be consolidated on the central server but no other changes will be propagated out.