This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 96%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHZ%3C/text%3E%3C/svg%3E)
Hi. Is it possible to use Azure SQL Database elastic query (https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview) on an Azure SQL Database emulator (https://learn.microsoft.com/en-us/azure/azure-sql/database/local-dev-experience-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'.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi Hubert Zięciak •,
Just checking in to see if the provided suggestion helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know. Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 34%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
@SSingh-MSFT I am trying still trying to clarify if it helped since we may encounter a similar issue if it wont work on two emulated databases.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 64%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
I'm seeing the same issue when I try to use the emulator. Creating the scoped credential works fine, but the 'create external data source' command fails with the same error: Incorrect syntax near 'RDBMS'. If I run the SQL on an Azure SQL instance, it works fine.
Hi Jason •,
This is strange and not expected. I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you. Thanks
Well, it seems to work on my test if you try to connect to a real Azure SQL Database.
Make sure you create a DATABASE SCOPED CREDENTIAL with its identity and secret.
The Location on the CREATE EXTERNAL DATA SOURCE should be 'logicalservername.database.windows.net'.
@Alberto Morillo How to use it though for two SQL Databases hosted within Azure SQL Database emulator? Is there a way? We have two databases which we'd like to develop for locally.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
@rafal Kuc Would SQL Data Sync work for you, where you can have a local replica of a Production database, and you can configure monthly, manual one-way replication from Production to your local environment?
Hello! Thank you for the question. Our usecase is replication of the Azure environment locally which means we dont want connection from emulator to an Azure resource but connection from emulated sql database to another emulated sql database hosted on a local machine. There are some scripts which sync two production databases using Azure SQL Database elastic query. What would work for us is two locally hosted emulated databases that can use the same method (which is dependent on an Azure SQL Database elastic query). This way we can have similar environment both on local machine and production for the development purpose.
Azure SQL Database Emulator does not allow elastic queries to another emulated Azure SQL Database based on my own tests. It only allows elastic queries to real Azure SQL databases.