"RDBMS"附近的语法不正确.当我尝试创建外部数据源时，有人遇到同样的问题吗? [英] Incorrect syntax near 'RDBMS'. When I try to create external data source, Anyone having the same issue?

问题描述

//我正在使用SQL Server 2017

//I am using sql server 2017

CREATE EXTERNAL DATA SOURCE MyElasticDBQueryDataSrc WITH
    (TYPE = RDBMS,
    LOCATION = '<servername>.database.windows.net',
    DATABASE_NAME = 'db1',
    CREDENTIAL = ElasticDBQueryCred
) ;

推荐答案

我正在使用sql server 2017

I am using sql server 2017

当前仅在Azure SQL数据库上支持RDBMS外部数据源.

RDBMS External Data Sources are currently only supported on Azure SQL Database.

-- Elastic Database query only: a remote database on Azure SQL Database as data source   
-- (only on Azure SQL Database)  
CREATE EXTERNAL DATA SOURCE data_source_name  
    WITH (   
        TYPE = RDBMS,  
        LOCATION = '<server_name>.database.windows.net',  
        DATABASE_NAME = '<Remote_Database_Name>',  
        CREDENTIAL = <SQL_Credential>  
    )  
[;]  

请参见在SQL Server 2017上，您可以使用

On SQL Server 2017 you can use Linked Servers

这篇关于"RDBMS"附近的语法不正确.当我尝试创建外部数据源时，有人遇到同样的问题吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！