Forum Discussion
How to create Azure SQL Server Views that reads data from a Dataverse?
Hi, I have an Azure SQL Server installed. I would like to create SQL Views within a SQL database on this server. These SQL Views will point to and show data held within our Dataverse (the database f...
AzureNewbie1 , Linked Server are not supported on Azure SQL Databases, see
Linked Servers (Database Engine) - SQL Server | Microsoft Learn
olafhelper - thanks. Are you able to advise on how I do fully qualify a Dataverse from within Azure SQL Server database?
AzureNewbie1- You may want to examine whether switching to an Azure SQL Managed Instance solution from an Azure SQL Database is worthwhile. Linked servers are permissible with Azure SQL Managed Instances.
- There are some alternatives, bit I don't know your requirements, so I can't say, what to use instead.
