I need to merge several databases that are isolated from each other on different machines that are in different places into one central database and turn it once unified send all data to the machines to have the same information central server. The unification would take place once in a while. I have read in the help of sql server you could do with the publication of mixtures but when I try it tells me I have to add a field in all tables of type foreign. All tables of the databases that attempt to unify with a field (called code) that is itself a unique index that cannot be repeated, but of course this field is in and I generate the values on my application, i.e. it is not, nor foreign Indentity. Also I cannot change the structure of databases as there is an application that works as is and if I change a table gives me errors in the application. How I can then apply merge replication or other or do otherwise without replication without having to alter the structure of databases?
Bookmarks