When you try to deploy an Azure SQL database with an update that is enabled in the Publish to Internet dialog box, the following error appears:
The remote host does not have the dbDacFx web deployment provider installed, which is required to publish the database. Learn more about this link.
FWLink: http://go.microsoft.com/fwlink/?LinkId=246068
Usage: RTM, SQL Server 2012, Windows 7 Ultimate
Project Type: MVC 4.0 (API)
Connection string:
Server=tcp:SERVER.database.windows.net,1433;Database=DB_NAME;User ID=Me@Server;Password=PASSWORD;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
Other: . Firewalls are open for my testing IP. The source database is located in the local instance. Destination DB was originally set to the new View mode, but I also reproduced it by standard. No EntityFramework (not allowed "Update database"). Disabled firewall when publishing, inaction.
source
share