NAV2013 - Convert your Beta database to the RTM

I just ran into a small 'oops' moment just now.

While the RTM version of NAV2013 is release last week, I decided to updat my client from the beta version to the RTM version.

This is what happened:

• I uninstalled the beta client and servers/services
• I installed the RTM client and servers/services
• I then tried to open my 'beta"-database with the new client.

This is wher everything halted with the message that the database had to be converted. Ok, this is no problem in this case. But when I clicked 'OK', I got the error that the database could nog be converted because there were objects locked in de database. Off course this was a beginners mistake but how to correct it without uninstalling the RTM and re-installing the beta client, unlocking the objects.. etc?

If you run into this problem, this is one solution:

Open your SQL Server Management Studio and input the following query in while connected to the correct SQL instance. (Replace "Demo Database NAV (7-0)" with your own database name)

 UPDATE [Demo Database NAV (7-0)].[dbo].[Object]
   SET [Locked] = 0
         ,[Locked By] = ''
 WHERE [Locked] = 1
 GO

Run the query and close your SQL Server Management Studio before retrying the conversion!

It's just one of those mondays...