Once your elastic database pool is up and running, you can add databases to it; to do so, follow these steps:
- Navigate to the SQL Server in which you created the pool.
- Then, go to SQL elastic pools and click on the pool that you want to add databases to.
- A new blade will open. In the Overview blade, click on Create database, as shown in the following screenshot:
- A new blade will open, where you will have to specify the following:
- Database name: Provide a name for the database.
- Select source: The source for the database.
- Collation: Database collation defines the rules that sort and compare data, and cannot be changed after database creation. The default database collation is SQL_Latin1_General_CP1_CI_AS:
- When you are done, click on OK, and a new database will be created and added to the pool.