With Microsoft Dynamics NAV, if you try to open a database created with a version older than the current client version (from example a 4.0 SP2 database opened with a 4.0 SP3 client), the system prompts you with a message that says something like "The database must be converted to the new version. Are you sure?". If you press the YES button, the db is automatically converted to the new version.
But what can you do if you want to rollback this upgrade? There's not an official way for doing this, but if you're running a SQL Server database you can hack the databaseversionno field in the $ndo$dbproperty table.
This field is upgraded on every database conversion. If you change the field value from 60 to 40 you should be able to open your database with the old SP2 client.
Hope this helps someone...
Technorati Tag:
Dynamics NAV