本地数据网关，无法以名称句点连接到SQL Server DB [英] On-Premise Data Gateway, cannot connect to SQL Server DB with period in name

问题描述

I'm trying to connect to a SQL Server database with the On-Premise Data Gateway, but unfortunately I have a period in the name of the database (yes, I know it's a bad idea). The gateway will successfully connect to databases without a period in the name, but I can't escape the name.

例如:

数据库名称:Foo.Fighters我尝试过[Foo.Fighters]和"Foo.Fighters"在数据库"字段中没有运气.

Database name: Foo.Fighters I've tried [Foo.Fighters] and "Foo.Fighters" in the Database field with not luck.

一旦将其更改为同一服务器上的其他数据库，我们一切都很好.

As soon as I change it to a different DB on that same server, we're all good.

推荐答案

马克，

我看到两个选择:

1)

1) Copy Databases with Backup and Restore (SQL Server)

2)

2) Rename a Database (SQL Server & Azure SQL Database)

请澄清一下，您希望重命名的SQL DB实例位于本地SQL Server上，还是Azure SQL数据库实例?

Just to clarify, the SQL DB instance you wish to rename resides on an on-premise SQL Server, or is this an Azure SQL Database instance? 

谢谢

迈克

这篇关于本地数据网关，无法以名称句点连接到SQL Server DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！