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 s should be sent to one centralised database.
How can I implement this ??