Data Sync -

We are working on the Microsoft Azure platform where we have two database servers, what is desired is to synchronize the databases from one server to another. Using the 'Synchronize' tool through the creation of a 'Group Sync' where we add the databases to be synchronized, the problem arises when Azure requests that the scheme database is updated by clicking on the 'Refresh scheme' button, it is worth noting that the scheme has been updated in this way several times and the problem persists. Schedule an image with error that the platform throws (https://social.msdn.microsoft.com/Forums/getfile/681638).

Reference is schema database is visible through SQL Server.


June 19th, 2015 7:14pm

Hi Gary, thank you for answering

In this link you will find the image with error (https://dl.dropboxusercontent.com/u/73018218/Captura%20de%20pantalla%202015-06-19%2013.18.13.png).

And we verify the database and all tables containing the respective PK and an index.
Free Windows Admin Tool Kit Click here and download it now
June 24th, 2015 6:15pm

Is the schema different between the hub and the member? From the log, schema can be obtained successfully from the member db but failed from the hub. If the schema of them are the same, You will be able to see the schema on browser if the member(not the hub) is selected in ''DEFINE SYNC RULES'' step(Please help to confirm that).

For the error hub failed to obtain schema, we can see an error message "Operation not supported on version 11.0 SqlAzureDatabase.". The root cause for this error is still in investigation.

Welcome to send email to jiaqz@microsoft.com. 

Regards,

Gary

June 27th, 2015 6:08am

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

Other recent topics Other recent topics