Check for previous/existing GitHub issues

• I have checked for previous/existing GitHub issues

Issue Type?

Feature Request

Module Name

avm/res/sql/server

(Optional) Module Version

0.7.0

Description

I can't see that it is possible to add a sqldb resource (Microsoft.Sql/servers/databases) to an existing br/public:avm/res/sql/server instance. It always have to be added at the same time as the server as a parameter to the server bicep module. We have a resource group where we store data for several services. We have a bicep script for the common infrastructure (like the sql server etc.) and then we have a separate bicep scripts for each service which add resources to that resource group later on. As of now the common bicep script need to know all the databases and add them to the server as you create the server. Can we get the possibility to add the databases separately?

It could be as easy as making the bicep script for the database available in br/public.

Sidenote: This may apply to other resource types which as well (e.g. blob containers in a Storage Account?). Is there a design reason behind this way of constructing the bicep modules?

(Optional) Correlation Id

No response