Migrating Database from SQL Server to Azure using BACPAC file

Question

I have a BACPAC file that I exported from SSMS with my schema as well as data, currently in my local disk.

The next step would be to upload the BACPAC file into a Blob Container and then import from my Azure SQL Server. Is there no way I can import the BACPAC file in my local disk directly to the Azure database without uploading it to a Blob container first?

If not, can someone explain what necessitates this intermediate step?

Answer 1

Use the Data-Tier Application Wizard. Got to the Object Explorer, right-click Databases and choose Import Data-tier Application. On the Import Settings page, choose Import from local disk.