Upgrading CLM 4.0.5 to CLM 5.0

That is your best option, open a PMR and engage with the support contact and request a webex or con call to review your upgrade strategy. We always send in with our PMR our written procedure we plan to execute for the upgrade or other significant change. We then have a call and we have a test system we use to execute first. For the scheduled upgrade ensure you have a PMR open indicating you are upgrading so that the escalation for assistance is ready on IBM side should things not work as planned. Within our plan we submit we also ask for backout plan should things not go well. We have had success with doing the first server migration with 4.0.0.1 with IBM assistance and have had a few other upgrade scenarios where they have been most helpful in keeping us from experiencing unnecessary downtime. We have not had to execute any PMR's opened during 4.x upgrades since 4.0.0.1 we are on 4.0.6 using Websphere and SQL 2008. But its a great safety net. Hope this helps

 Well I would try it in a sandbox first if you can - seems a lot of extra work to go to 4.0.7 to get to 5.0.  I don't use windows or SQL server but I would expect the transition to 2012 to be fairly painless - I would definitely make full backups of the 4.0.5 system before starting just in case something goes wrong.  I would upgrade the db server then make sure you can connect to it.  You could actually connect with 4.0.5 - it will give you a warning on the db server mismatch but I believe it will still work.  Then shutdown 4.0.5 and proceed to upgrade to 5.0.  I have done it this way with DB2 so I would expect SQL Server to behave similarly.

 I think that's a reasonable phased approach that will allow you to upgrade your backend database and then upgrade your application.

 We are on CLM 4.0.3 and  "Database version: Microsoft SQL Server 11.00.3373" which is SQLserver 2012 SP1.

Thank you every one for your suggestion.