SQL server synchronisation

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

February 20th, 2015 3:58pm

Hi,

Thanks for posting here.

We are looking into this query posted by you. I have engaged our SQL experts. Stay tuned for details.

Girish Prajwal

Free Windows Admin Tool Kit Click here and download it now
February 23rd, 2015 3:05am

Hello Serge,

I believe DTOs(Data Transformation Objects), used as mentioned in http://azure.microsoft.com/en-us/documentation/articles/mobile-services-dotnet-backend-use-existing-sql-database/ should work for your scenario.

Please let us know if this isn't your main concern - mapping database objects in retail DB to LIVE-CPY_SERVER.

Regards,

Kumar Bijayanta

February 24th, 2015 3:30am

Hello Serge,

I believe DTOs(Data Transformation Objects), used as mentioned in http://azure.microsoft.com/en-us/documentation/articles/mobile-services-dotnet-backend-use-existing-sql-database/ should work for your scenario.

Please let us know if this isn't your main concern - mapping database objects in retail DB to LIVE-CPY_SERVER.

Regards,

Kumar Bijayanta

Free Windows Admin Tool Kit Click here and download it now
February 24th, 2015 8:31am

Hello Serge,

I believe DTOs(Data Transformation Objects), used as mentioned in http://azure.microsoft.com/en-us/documentation/articles/mobile-services-dotnet-backend-use-existing-sql-database/ should work for your scenario.

Please let us know if this isn't your main concern - mapping database objects in retail DB to LIVE-CPY_SERVER.

Regards,

Kumar Bijayanta

February 24th, 2015 8:31am

Hello Serge,

I believe DTOs(Data Transformation Objects), used as mentioned in http://azure.microsoft.com/en-us/documentation/articles/mobile-services-dotnet-backend-use-existing-sql-database/ should work for your scenario.

Please let us know if this isn't your main concern - mapping database objects in retail DB to LIVE-CPY_SERVER.

Regards,

Kumar Bijayanta

Free Windows Admin Tool Kit Click here and download it now
February 24th, 2015 8:31am

Hello Serge,

I believe DTOs(Data Transformation Objects), used as mentioned in http://azure.microsoft.com/en-us/documentation/articles/mobile-services-dotnet-backend-use-existing-sql-database/ should work for your scenario.

Please let us know if this isn't your main concern - mapping database objects in retail DB to LIVE-CPY_SERVER.

Regards,

Kumar Bijayanta

February 24th, 2015 8:31am

Thnaks for your reply.

Does that means that DTO can work with different type of retail database structure ?

What I mean by that is, will I have to create or run a new DTO process for each retail database I will have to handle ?

regards

serge

Free Windows Admin Tool Kit Click here and download it now
February 25th, 2015 2:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics