Hey everyone! I set up a static web app back in August using Microsoft's guide, which helped me connect to a SQL database via database connections (which is now in preview). However, I just got an email saying this feature is going away and that I need to switch to the Data API builder by November 1. The documentation isn't very clear on how to migrate. Does anyone have advice or resources to help me with this transition? By the way, I searched online and found conflicting information about this change; some sources seemed to dismiss the email I received.
2 Answers
Just an update! I found this [page](https://learn.microsoft.com/en-gb/azure/data-api-builder/quickstart/mssql) that helped me create a dab-config.json file for my local Docker SQL Server instance. If you set it up with your schema, the Data API Builder will generate the right entities for you. It also has a nice Swagger UI for testing the REST APIs. I’m switching over from Entity Framework to JsonSerializer since my app will now rely on REST APIs. Once I get my app working locally, I’ll focus on using my Azure dev database and then deploy everything to Azure.
I totally get where you're coming from! I'm also in a similar boat having built a static web app for a charity. Definitely had to learn a lot on the fly! You're right, the email and the links don’t offer much guidance. For now, I’m breaking down my migration into smaller steps. I'm trying to set up Data API Builder with a Docker SQL Server locally. It seems like a good way to get familiar with the REST endpoints. Once that’s running, I’ll tackle how to connect and deploy my Azure database. If you want to share ideas or collaborate, I’m all in!

Related Questions
How to Build a Custom GPT Journalist That Posts Directly to WordPress
Cloudflare Origin SSL Certificate Setup Guide
How To Effectively Monetize A Site With Ads