Allow New-AzSqlDatabaseImport to create a vCore-based database

Azure / azure-powershell

Microsoft Azure PowerShell

Other

4.27k stars 3.87k forks source link

Allow New-AzSqlDatabaseImport to create a vCore-based database #12791

Open grrlgeek opened 4 years ago

grrlgeek commented 4 years ago

Currently, New-AzSqlDatabaseImport accepts -Edition and -ServiceObjectiveName , which allow you to create a DTU-based SQL Database. However, I want to create a vCore-based SQL Database.

I'd like to see new optional parameters added.

-Edition would be the General Purpose/Business Critical/Hyperscale tier
-Vcore would be the number of vCores assigned
-ComputeGeneration would be Gen5, F-Series, etc.

This is in line with the parameters for New-AzSqlDatabase.

This is the code I'd like to run:

New-AzSqlDatabaseImport -DatabaseName $SQLDB -Edition $DBEdition -Vcore $Vcore -ComputeGeneration $Gen -DatabaseMaxSizeBytes $DBSize -ServerName $SqlServerName -StorageKeyType 'StorageAccessKey' -StorageKey $StorageAcctKey -StorageUri $StorageUri -AdministratorLogin $SqlAdminUser -AdministratorLoginPassword $SqlAdminPass -ResourceGroupName $RGName

ghost commented 4 years ago

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub.

dingmeng-xue commented 4 years ago

SQL team, please help to look into this requestion.

jdennis17 commented 3 years ago

Is there any update on adding the vcore parameter option? I too am running into this problem when creating a database from a bacpac file.

bdo-ca commented 3 years ago

Any update on this issue? i need this functionality too.

alvipeo commented 3 years ago

Any updated on this???

grrlgeek commented 3 years ago

I've tried to test this with different combinations of -Edition and -ServiceObjectiveName, with no success. Please let us know when the option to use vCore will be available. The work to create a DTU database then convert to a vCore database is unnecessary.

CarstenMertes commented 2 years ago

Hi, could you please give us an update?

ksl28 commented 1 year ago

Any updates on this matter Microsoft? I just spend several hours debugging on this, just to realize its a known limitation for several years. Its not ideal to have, to import it as a DTU database, and then change it afterwards.

Nullh commented 7 months ago

Hello, just adding my voice in here to ask if this is ever going to be implemented? Seems like a big oversight. We should also be able to create the imported database in an elastic pool.