search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.2k stars 21.34k forks source link

.bacpac files do NOT seem to be supported #39072

Closed 4deeptech closed 4 years ago

4deeptech commented 4 years ago

This article states that most of the migration tools are supported and lists bacpac as an option. The portal specifically blocks imports via bacpac for Hyperscale, SqlPackage utility indicates the 'Hyperscale' is not a valid 'edition', and MGMT Studio does not list Hyperscale as an option.

If bacpacs are supported can you please update this to explain exactly what tooling can be used to do this with some examples and tool version info?

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

NavtejSaini-MSFT commented 4 years ago

@4deeptech We are looking into this and will get back to you.

NavtejSaini-MSFT commented 4 years ago

@4deeptech We are assigning this to author for further action. @stevestein The bacpac import into a Azure SQL Server is not available. Please let us know if we can modify the document to mention this limitation. Hyper

stevestein commented 4 years ago

reassign:dimitri-furman

stevestein commented 4 years ago

@dimitri-furman - can you assist here? Thanks!

dimitri-furman commented 4 years ago

@4deeptech - thanks for reporting this. bacpac import/export to/from Hyperscale is now supported in DacFx framework (SqlPackage) v18.4, as well as in SSMS v18.4.

stevestein commented 4 years ago

please-close

blueelvis commented 4 years ago

@dimitri-furman - Any idea when would this support be coming in the form of Portal Integration with PowerShell cmdlets and REST API integration to do bacpac imports?

dimitri-furman commented 4 years ago

@blueelvis - No immediate plans to enable bacpac import/export in the portal or via PowerShell/REST API for Hyperscale databases. The bacpac technology would not work well for larger databases likely to be found in the Hyperscale service tier.

In addition to the current workaround using SqlPackage v18.4 or later on a VM, you can import smaller databases in a non-Hyperscale service tier, and then migrate the database to Hyperscale.