Sync Multi Remote Databases to a single Database
I am using SQL Compare SDK in a C# service to sync 20 tables in 50 remote databases to a common server in our data center. This working VERY well. However, I end up with 50 databases on the data center server. It would be extremely helpful if those 50 databases could sync to a single database. The only difference in the schema in the remotes databases and the single combined database would be a location id.
Does anyone know if this is possible using this tool? If so, are there any examples?
Thanks so much in advance for your help