You add a new Azure SQL Database single database to an existing database server.
You need to add the database to an existing elastic pool.
Which PowerShell cmdlet should you use?
You should use the Set-AzureRmSqlDatabase cmdlet. This cmdlet modifies the properties of an existing database, which includes adding the database to an elastic pool. You would run a command similar to the following:
Set-AzSqlDatabase -ResourceGroupName RGDB1 -ServerName DBServe1
-DatabaseName DB12 -ElasticPoolName MyPool
You should not use the Set-AzureRmSqlElasticPool cmdlet. This cmdlet lets you modify elastic pool properties, such as pool size, minimum DTUs, and maximum DTUs. It does not let you add databases to or remove databases from the pool.
You should not use the Set-AzureRmSqlDatabaseSecondary cmdlet. This cmdlet is not used to manage elastic pools. It is used to switch a secondary database to be the primary database to initiate failover in a fault tolerant configuration.
You should not use the Set-AzureRmSqlInstance cmdlet. This cmdlet is used to set properties for an Azure SQL Database Managed Instance. A managed instance cannot be part of an elastic pool.