为什么未显示碎片数据库的表? [英] Why Shard Database's Tables are not shown?

问题描述

你好

我正在使用弹性数据库工具在Azure SQL数据库中添加分片数据库.我使用了从以下链接下载的示例代码:

I'm using Elastic Database Tools for adding shard databases in Azure SQL Database. I used sample code which was I downloaded from below link:

https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-elastic-scale-get-started

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-scale-get-started

代码工作正常.碎片数据库及其表也可以完美生成.

The code working fine. Also the shard databases and its tables are generated perfectly.

但是，当我想将数百万条记录转储到分片数据库表时，我担心的是.为了生成记录，我使用了第三方工具.在该工具中，无法获取特定分片数据库的表，因此我无法为分片数据库生成记录. 对于其他数据库，它工作正常(如果我直接在Azure SQL服务器上创建数据库，那很好，但是如果使用上面的链接代码创建数据库，那么它就不会获取表名).

But my concern is there when I want to dump millions of records to shard database tables. For generating records I'm using an third party tool. In that tool particular shard database's tables are not fetch so I'm unable to generate records for shard databases. For other databases it's working fine(If I create database direct on Azure SQL server then its fine but if the databases are created using above link code then it's not fetching table's name).

是否存在权限问题?

推荐答案

你好

我正在使用弹性数据库工具在Azure SQL数据库中添加分片数据库.我使用了从以下链接下载的示例代码:

I'm using Elastic Database Tools for adding shard databases in Azure SQL Database. I used sample code which was I downloaded from below link:

https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-elastic-scale-get-started

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-scale-get-started

代码工作正常.碎片数据库及其表也可以完美生成.

The code working fine. Also the shard databases and its tables are generated perfectly.

但是，当我想将数百万条记录转储到分片数据库表时，我担心的是.为了生成记录，我使用了第三方工具.在该工具中，无法获取特定分片数据库的表，因此我无法为分片数据库生成记录. 对于其他数据库，它工作正常(如果我直接在Azure SQL服务器上创建数据库，那很好，但是如果使用上面的链接代码创建数据库，那么它就不会获取表名).

But my concern is there when I want to dump millions of records to shard database tables. For generating records I'm using an third party tool. In that tool particular shard database's tables are not fetch so I'm unable to generate records for shard databases. For other databases it's working fine(If I create database direct on Azure SQL server then its fine but if the databases are created using above link code then it's not fetching table's name).

是否存在权限问题?还有其他方法可以获取这些表吗?

Is there any permission issue? Is there any other way to fetch those tables?

>>  为了生成记录，我使用的是第三方工具.在该工具中，特定的分片数据库的表无法获取

>> For generating records I'm using an third party tool. In that tool particular shard database's tables are not fetch

您似乎最好的选择是联系第三方工具公司或他们的论坛

It sound like your best option is to contact the third party tool company or their forums

>>  如果我直接在Azure SQL服务器上创建数据库，那很好，但是如果使用上面的链接代码创建数据库，则它不会获取表名

>> If I create database direct on Azure SQL server then its fine but if the databases are created using above link code then it's not fetching table's name

当您尝试使用样本中的Db时，您确定您的应用程序不直接指向共享数据库之一吗?

Are you sure that your app does not point directly to one of the shared databases,when you tried to use the Db from the sample?

我觉得我需要有关第三方应用程序功能的更多信息...

I feel like I need more information about what the third party app do...

这篇关于为什么未显示碎片数据库的表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！