从本地数据库(MS SQL 2012 Server)到Azure的数据同步正在加载表 [英] Data sync from Local DB (MS SQL 2012 Server) to Azure is loading the tables

问题描述

我将按照本指南中的步骤将包含800多个表的实时工作数据库连接到Azure.我的目标是定期创建< g class ="gr_gr_141 gr-alert gr_spell gr_inline_cards gr_run_anim Contextual Spelling的备份 因斯德尔data-gr-id ＝"141". id ="141"，所以< g class ="gr_ gr_212 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id ＝"212". id ="212" i/g g/g. 可以使用Azure中的数据库来将其用于Analytics(分析)目的.

Im following the steps in this guide to connect a live working DB consisting for 800+ tables to Azure. My objective is to set up a backup at regular intervals <g class="gr_ gr_141 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="141" id="141">so <g class="gr_ gr_212 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="212" id="212">i</g></g> can use the DB in Azure to use it for Analytics purposes. 

到达步骤3后，https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-get-started-sql-data-sync#step-3---configure -sync-group表未加载，并在< g class ="gr_gr_302 gr-alert gr_gramm gr_inline_cards gr_run_anim语法仅限于doubleReplace replaceWithoutSep" data-gr-id ＝"302". id ="302"> log</g>:

After I reach Step 3 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-sql-data-sync#step-3---configure-sync-group the tables are not loading and getting an error as follows in <g class="gr_ gr_302 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" data-gr-id="302" id="302">log</g>: 

由于不支持带有'.'，'['或']'的数据库对象名称"的异常，因此获取数据库的模式信息失败.有关更多信息，请向客户支持提供跟踪ID"88bed34a-f6d1-4101-b347-ad6986790e3a".

Getting schema information for the database failed with the exception "Database object names with a '.', '[' or ']' are not supported. For more information, provide tracing ID ‘88bed34a-f6d1-4101-b347-ad6986790e3a’ to customer support."

推荐答案

Sanjay，

Hi Sanjay,

如果我理解您的问题，则本地数据库命名约定与Azure SQL数据库所需的命名约定不兼容.您能否提供有关如何使用本地数据库设置数据库命名约定的示例，包括 SQL Server名称，SQL数据库名称和受影响的数据库中的表名称.

If I understand your issue, the on-premise database naming convention is not compatible with the naming convension required for Azure SQL Database. Can you provide examples of how you have set-up the DB naming conventions with your on-premise database including SQL Server Names, SQL database Name, and table names within the affected database.

谢谢

迈克(Mike)

这篇关于从本地数据库(MS SQL 2012 Server)到Azure的数据同步正在加载表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！