Dear all,
I have a wierd issue to solved in a Aazure sql architecture. First of all let me explain what we have so far :
Under Azure we have a SQL server database which host Product configuration organised in categorie. This database is configured through our own CMS web Platform.
Lets call that Server : SQL-CMS-SERVER
Then we have an interactive application which is connected to that server and display product to user. The interactive application is standard and tight to our CMS configuration.
When we distribute our application in Reatail shop, usually shop have there own product database ciming from a wharehouse and do note allows anyone to get into directly.
In order to use our interactive application for retail, we absolutly need to get shop product catalog duplicate in our own database.
what we try to reach :
- We need to have a live copy of store product into our Azure account in a server called for instance LIVE-CPY-SERVER
- The LIVE-CPY-SERVER should be able to sync new data from Customer retail db ( we admit it is SQL as well)
- The LIVE-CPY-SERVER should be then able to push updated data to our product server SQL-CMS-SERVER
The key point is that we need to have a common structure Db for LIVE-CPY-SERVER for any shop in order to avoid to change db structure all time. That means we need to setup a kind of mapping table between the Retai Db and our DB in order to that sync should be possible all time.
Any idea how to approach this ?
regards
serge