Azure SIngle DB serverless with multiple database, will it cost same or more?

Question

Hi All,

Once an Azure Single DB with serverless configuration is provisioned, can we create multiple DBs (Using 'CREATE DATABASE')?

If this is possible , do we need to pay the same amount or it is going to increase?

Regards,
Prateek

Answer 1

One Azure SQL logical server can have databases of many types created on it as shown below:

On this image you can see a serverless database paused along with other 3 DTU-model databases (1 premium, 1 standard, 1 basic). Every time you create a database you will have to specify is a serverless databases and each created serverless database will be billed separetely.

One option you have available is to consolidated all your databases into one serverless database, by creating a separate schema for each database inside the Azure Serverless database. This way you can migrate your existing database into one single serverless database, and be billed by one database only. Each existing database will have its data migrated to different schema inside the serverless database.

Another option you have if all the databases you want to consolidate have the same schema, you may first think about merge these data into one database, then deploy the database to Azure Serverless database.

Answer 2

Hi @prateek chaturvedi

Thank you @Alberto Morillo for helping so many customers on forums.

Yes. You can create databases in an elastic pool using CREATE DATABASE, and create schemas in each database in the same way as when a database is not in an elastic pool.

Regards,
Oury