Adding a database to an elastic pool

Once your elastic database pool is up and running, you can add databases to it; to do so, follow these steps:

  1. Navigate to the SQL Server in which you created the pool.
  2. Then, go to SQL elastic pools and click on the pool that you want to add databases to.
  1. A new blade will open. In the Overview blade, click on Create database, as shown in the following screenshot:

  1. 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.
    • CollationDatabase 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:

  1. When you are done, click on OK, and a new database will be created and added to the pool.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset