My problem is to centralize entire databases which running on different sites.
Basically i have 5 different databases running on 5 different sites.
What i want to do is to make them communicate by integrating them with one centralize repository.
All the running databases have certain amount of records.which i want to migrate into new common centralize database.
I cant not change the scheme or another behavior of the running systems. Whatever i can do is in new centralized databases.
New database should reduce the redundancy too.