Hey everyone! I built a website, and I want every registered user to have their own separate database. Is there an Azure service that allows this while also giving me full control over the server? Any advice would be appreciated!
1 Answer
You can set up a single Azure SQL server and attach multiple databases to it. There’s definitely a limit to how many databases you can connect to one server, but it might be worth checking out the specifics. Just remember, you will pay for every database depending on its size and performance. Alternatively, if you go for an Azure SQL Managed Instance, you can create as many databases as you want without additional charges, but keep in mind that the managed instance itself can be pricey. Also, you're typically limited to around 100 or 200 databases in such instances. Just a heads-up, it feels like a design choice that might need to be reconsidered if each user isn't generating substantial revenue.
I agree, your best bet is definitely to create one Azure SQL server and multiple databases. The limits are there, but trying to manage multiple users with a single database using something like tenant IDs isn't practical for privacy.