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 正在进行一项网上调查，以了解您对 Msdn 网站的意见。如果您选择参加，我们将会在您离开 Msdn 网站时向您显示该网上调查。