Data Sync - Data Hub Selection

Question

Hello,

We run several data-driven web sites in Azure. We currently use RedGate's free product for regularly backing up the SQL Azure databases to our local continuous integration server. This ensures that we always have up-to-date data for development and testing.

We have been considering using DataSync (not bi-directional) to push changed data on the web site down to our continuous integration server. Is it okay to use the production web database as the Hub? Or do we need to create a separate hub?

Our primary goal is to sync our on-premise SQL database with the production web database. 

Thanks!,

Andrew

Answer 1

you can use your existing SQL Azure DB as the hub.

a hub is basically just a central point where every sync operation passes thru. if you create a new hub, that means the sync will go thru the hub first then go to your local db.