C# Import from bacpac to Azure and add database to Elastic pool

Question

I need to create a database in SQL Azure importing schema and data from a BACPAC file.

I use the method ImportBacPac of the DacServices object. I see that I can specify some options using DacAzureDatabaseSpecification (Edition, Maximum size...)

I wonder if there is a way to connect the database to elastic pool while importing it from bacpac.

Thank you

Answer 1

Importing to a database in elastic pool isn't supported. You can import data into a single database and then move the database to an elastic pool.

Once you have it in same Logical Server. Move the DB under Elastic Pool. You can do this in C#, the Portal, Using PowerShell, or using simple query as below:

 ALTER DATABASE Your_DB_Name
     MODIFY ( SERVICE_OBJECTIVE = ELASTIC_POOL ( name = Your_Pool_Name) ) ; 

Note: You can create multiple pools on a server, but you can't add databases from different servers into the same pool.