Which publishing method should you use?

You have a web application that was developed by using Microsoft ASP.NET MVC. The application is deployed
to an Azure web app and uses an Azure SQL Database.
From a development environment, you use Microsoft Visual Studio to change the application code, and you
modify the schema of the database.
You need to deploy the changes to Azure.
Which publishing method should you use?

You have a web application that was developed by using Microsoft ASP.NET MVC. The application is deployed
to an Azure web app and uses an Azure SQL Database.
From a development environment, you use Microsoft Visual Studio to change the application code, and you
modify the schema of the database.
You need to deploy the changes to Azure.
Which publishing method should you use?

A.
BACPAC

B.
FTP

C.
Msdeploy

D.
Robocopy

Explanation:
You can deploy a .bacpac file to an Azure SQL Database using an Azure Resource Manager
Template. .bacpac contains the schema and data necessary to deploy your database.
Note: A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from a SQL
Server database. A BACPAC file can be stored in Azure blob storage or in local storage in an on-premises
location and later imported back into Azure SQL Database or into a SQL Server on-premises installation.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-export



Leave a Reply 6

Your email address will not be published. Required fields are marked *


null

null

Isn’t it C. Msdeploy? Since you’d want to deploy changes to the application code and the changes to the db schema..

Asd

Asd

Yes, it’s msdeploy. BACPAC contains only changes to the db schema and data.

savel

savel

its bacpac.

Chriss Leong

Chriss Leong

Answer should be Msdeploy. Because with BACPAC we only have the db changes. Question asks both db and application changes deployment.

ven

ven

yes, it is msdeploy. application changes and sql changes.