VERIFIED SOLUTION i

How to ensure the database does not get corrupted when upgrading from DOC1 Designer 5.5 to 6.0

SQL 2005, Designer 5.5
SQL 2012, Designer 6.0
There have been some known issues where the database gets corrupted if the customer upgrades directly from SQL 2005 TO SQL 2012.

Engineering recommend upgrading to SQL 2008 and then SQL 2012.

Customer will need to perform these steps when upgrading:

1.) Create a backup of  5.5 Repository.
2.) Install version 5.6
3.) Restore 5.5 backup into 5.6 installation.
4.) Run the 'Repository Integrity Tool'.
5.) Create backup of 5.6 repository.
6.) Install version 6
7.) Restore 5.6 backup into 6 installation.
UPDATED:  October 31, 2017