I am trying to setup SQL Azure sync from my core database to a reporting database (both SQL Azure).  I successfully setup sync with my secondary (and smaller schema) database.  When I try to define the Sync rules and hit Refresh Schema it never finishes.  I've been trying to do this off/on for the last ~3 months so I don't think it is an intermittent issue.

SyncGroup - 9ea034c4-8fc6-43e8-a12f-a1e3d1479e25_EastUS

When I look at my web console I see:

Failed to load resource: the server responded with a status of 500 (Internal Server Error): https://manage.windowsazure.com/DataSync/RefreshCloudDbSchema

Similar (same issue?) from Sept 20, 2013

http://www.networksteve.com/forum/topic.php/SQL_Azure_Data_Sync_%27Refresh_Schema%27_Not_Working/?TopicId=41473&Posts=0

Thanks, Aaron

Hi,

Thank you for reaching out to us. Let me engage this post with someone who is more familiar with the topic. We shall revert back to you with an update at the earliest. Sincerely appreciate your patience.

Regards,
Prasant