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.