Forum Discussion
AzureNewbie1
Jul 03, 2024Brass Contributor
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...
olafhelper
Jul 03, 2024Bronze Contributor
AzureNewbie1 , Linked Server are not supported on Azure SQL Databases, see
Linked Servers (Database Engine) - SQL Server | Microsoft Learn
AzureNewbie1
Jul 04, 2024Brass Contributor
olafhelper - thanks. Are you able to advise on how I do fully qualify a Dataverse from within Azure SQL Server database?
- JEliahCroomJul 05, 2024Copper Contributor
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.
- olafhelperJul 04, 2024Bronze ContributorThere are some alternatives, bit I don't know your requirements, so I can't say, what to use instead.