Change Azure FHIR server database from CosmosDB to SQL Server.

Fred 26 Reputation points
2021-11-12T16:27:04.443+00:00
  1. How do I go about changing Azure FHIR server database from CosmosDB to SQL Server?
  2. What is the cost impact?

It's a new Azure Fhir server, so current data is not an issue and will be discarded.

Thanks

Azure SQL Database
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,631 questions
Azure Health Data Services
Azure Health Data Services
An Azure offering that provides a suite of purpose-built technologies for protected health information in the cloud.
161 questions
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
    2021-11-17T16:54:28.02+00:00

    Hi @Fred Thank you for posting your Question on Microsoft Q&A and sorry for the delay in response to your question.

    In managed service you don't have a way to switch underlying persistence provider. If you are using FHIR Service in Healthcare APIs (currently in Public Preview), then you are already using SQL in the backend). But in managed service you don't have access to the underlying database. In OSS you need to redeploy the FHIR Server with SQL option.

    In the future we will have ways to migrate from Azure Api for FHIR to azure healthcare APIs. If you want to do it now, you will have to reload.

    Hope that help

    Regards,
    Oury

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.