Sync Multi Remote Databases to a single Database

dsanders2424

Hi Friends,

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
Dan

Anu D

Hi,

Thanks for your post.

I have logged a support ticket for you and have already sent an email to you.