How to open Azure database .bacpac locally for local Umbraco website?

I exported and downloaded my database from Azure as a .bacpac file.

I want to install Umbraco locally and use this database locally.

How do I do it?

Every time when I open the Microsoft SQL Server Management Studio it tries to connect to the database on Azure:

Then when I put the password it will connect to the database on Azure:

But I want to work on the local .bacpac file.

My questions are:

How do I connect on the Microsoft SQL Server Management Studio to the local .bacpac file ?

How do I connect in the Web.config to the local database ? What should I put in the connectionString?

<connectionStrings>
    <remove name="umbracoDbDSN" />
    <add name="umbracoDbDSN" connectionString="Server=tcp:xxxxx.database.windows.net,1433;Data Source=xxxxx.database.windows.net;Initial Catalog=xxxx;Persist Security Info=False;User ID=xxxx;Password=xxxx;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=3600;" providerName="System.Data.SqlClient" />
</connectionStrings>

So basically I want to open and work on the local .bacpac and not on the one on the server, and only after I finish the work to deploy it back.

How do I do it?

Thanks

Here are the steps that you should follow;

• Connect to your local db.

• Select Import Data-tier Application.

• Select your .bacpac file.

• Give a name to your new database and hit finish.

• Create a new login or choose one of the existing ones and set the user mappings as follows so that you can connect to your new Umbraco db using this user's credentials.

• And here is how you can connect to your local db from your local Umbraco website:

  <add name="umbracoDbDSN" connectionString="server=localhost;database=YourNewUmbracoDbName;user id=youruser;password=yourpassword" providerName="System.Data.SqlClient" />