Enable PUT and DELETE in IIS
Context
Problem
Original Web.config:
<modules >
<remove name="FormsAuthentication" />
</modules>
<handlers>
<remove name="ExtensionlessUrlHandler-Integrated-4.0" />
<add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="*" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />
</handlers>
</modules >
Related errors:
Solution
Web.config:
<modules runAllManagedModulesForAllRequests="true">
<remove name="WebDAVModule" />
<remove name="FormsAuthentication" />
</modules>
<handlers>
<remove name="WebDAV" />
<remove name="ExtensionlessUrlHandler-Integrated-4.0" />
<add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="*" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />
</handlers>
</modules >
IIS:
How to Rollback a Database Migration From a Remote SQL Server
The scope of this solution is to explain how to recover from a desynchronization between your project database version and your remote server database. How to correctly rollback in both development and remote servers is out of scope.
Scenario:
Solution 1:
If you had open ports to connect to remotely to the SQL Server, then you simply do: update-database -targetMigration previous_to_the_last_migration.cs -ConnectionString "YOURCONNECTIONSTRING".
Solution 2:
Given that you do have access to the remote server by e.g. a RDP connection, we'll make use of SQL Server Management Studio (SSMS):