Symptoms

The following error can be received during the database upgrade to the newer version:

Checking identity information: current identity value '7114389'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 15336, Level 16, State 1, Procedure sp_rename, Line 565 [Batch Start Line 2727]
Object 'dbo.BatchParameter' cannot be renamed because the object participates in enforced dependencies.
Msg 207, Level 16, State 1, Procedure Batch_UpdateParameter, Line 17 [Batch Start Line 2856]
Invalid column name 'ProjectId'.
Msg 207, Level 16, State 1, Procedure Batch_UpdateParameter, Line 17 [Batch Start Line 2856]
Invalid column name 'BatchPurpose'.

Cause

There are multiple schema-bound views. SQL is preventing you from renaming the objects because of constraints to other tables/views in the database.

Resolution

In order to resolve the issue, please try to perform the following steps:

1. Check the views present for the Object mentioned in the error message.
2. Remove the views by dropping them.
3. Re-run the upgrade procedure.
4. Recreate the views.