CODEWITHSUNDEEP
azure-sql-databaseazure-elastic-sharding
BigP
BigP

Reputation: 1

Azure SQL Database elastic query on Azure SQL Database emulator

Is it possible to use Azure SQL Database elastic query on an Azure SQL Database emulator?

I installed an Azure SQL Database emulator and followed the instructions in Elastic Query getting started article and during execute:

    CREATE EXTERNAL DATA SOURCE MyElasticDBQueryDataSrc WITH
        (TYPE = RDBMS,
        LOCATION = 'XXX',
        DATABASE_NAME = 'Customers',
        CREDENTIAL = ElasticDBQueryCred
    ) ;

I get an error

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'RDBMS'.

Upvotes: 0

Views: 112

Answers (1)

Pratik Lad
Pratik Lad

Reputation: 8291

Azure SQL Database public service, some specific features may not be available. For example, the Azure SQL Database emulator does not support all features that are supported across multiple Azure SQL Database service tiers.

There is no limitation on the elastic query. Below query worke fine:

CREATE  EXTERNAL  DATA SOURCE [DataSource2] WITH
(
TYPE  =  RDBMS,
LOCATION  =  'pdstackserver.database.windows.net',
DATABASE_NAME  =  'db1',
CREDENTIAL  = ElasticDBQueryCred1
)

enter image description here

Upvotes: 0

Related Questions