Can I migrate from FHIR server Cosmos DB to FHIR server SQL server in Azure FHIR server?

Question

Hi

I have created a Azure FHIR server application, DB configured is Cosmos DB.

Since FHIR server Cosmos DB in Azure FHIR server does not supports transaction bundle, I wish to migrate to FHIR server SQL server.

How to do the migration? Also will the existing data gets migrated too?

Also please let me know the difference between two: FHIR server SQL server and FHIR server Cosmos DB? Is it good to migrate just because one does not support transaction type bundle operation?

Thanks

Answer 1

@P, Pioline (Cognizant) Thanks for reaching out. please let me know if you're using open source FHIR server or managed services Azure API for FHIR?

• FHIR Server for Azure https://github.com/microsoft/fhir-server OR managed service https://learn.microsoft.com/en-us/azure/healthcare-apis/azure-api-for-fhir/overview
• If you're looking to migration from open source FHIR server (Cosmos DB) to open source FHIR Server for Azure (SQL Server) you can review and consider using the open-source sample Migration tool on Github that you can review for the migration. https://github.com/Azure/apiforfhir-migration-tool/tree/main This tool support migration of existing data too.
• If you're looking to migrate managed service Azure API for FHIR to Azure Health Data Services,
• We have announced retirement of Azure API for FHIR (that has Cosmos DB backend) and recommend customers to migrate (including their FHIR data) to Azure Health Data Services - https://azure.microsoft.com/en-us/updates/azure-api-for-fhir-retirement/
• you can learn more about migration guidance here: https://learn.microsoft.com/en-us/azure/healthcare-apis/fhir/migration-strategies
• The sample open-source migration tool https://github.com/Azure/apiforfhir-migration-tool/tree/maincan be leveraged. I hope the answer helps. Please let me know if you have any further queries.