I would like to replicate multiple databases on different servers into one master database.
I have 5 different instances on separate servers all running SQL 2008 R2. The schemas and structure are all the same but the data is different. I need to replicate all the data into one database on a single instance. What would the best way going forward?
There's about 132 tables which need to be replicated. I tried creating publishers on each server and subscribing them to a single database on one instance but with no success: data is being over written and some servers are not replicating.
I probably have the wrong approach or messed up something along the way. Your assistance will be highly appreciated.