We are setting up the replication of an SQL Azure database but we get the following error while trying to get the schema information of this database:
"Getting schema information for the database failed with the exception "Unable to process a schema with XXXX tables, 500 is the max"
Is there a workaround to this problem, or any plan to remove this limitation in the near furtur.
As advised we are testing the following workaround listed here:
1) We create a temp database and create by script the tables we want to replicates on the database (less than 500 tables per synchronisation group)
2) We create our synchronisation group, with our source database as the main database, we add our temp table and our destination table
3) We select the tables we want to replicates from the temp table schema information
4) Finally we remove the temp table from the sync group
It seems to be working so far.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?