Reverting back to original version when converted Accidentally
Note : This Article gives an basic idea where the Version Reference is kept for a NAV Client. However values described this article may change from version to version. So before changing the value in dbproperty table, take necessary measures.
- There is a situation where by opening Navision databases with higher Navision versions will pop up a confirmation message whether you want to convert database. Once if you click “Yes” then you can’t use original Navision client to open your database anymore.
- This article explains you how to revert back the original version from converted version by taking an example as follows:
- For example I am taking Navision 6.0 SP1 database (i.e., Demo Database NAV (6-0)).
- Go to SQL server management studio and choose the Navision 6.0 SP1 database (i.e., Demo database NAV (6-0)) as shown above.
- Right click on “Demo Database NAV (6-0)” and select the “New Query”.
- Write the query and click on Execute button as shown above.
- Observe the SP1 database version as shown above (i.e., “databaseversionno” as 150).
- Note: For each database version/Service Pack/Hot Fix there will be unique “databaseversionno”
- Now try to open the Navision 6.0 SP1 database with R2 FinSQL.
- Opening the Demo Database NAV (6-0) with R2 FinSQL as shown above.
- While opening the database you will gets a window regarding converting the database and press “ok” as shown above.
- Click on “ok” to confirm to convert the database as shown above.
- The database conversion successfully completed and when clicked on “ok” as shown above.
- Go to SQL server management studio and observe the “Demo Database NAV (6-0)” version was changed as “databaseversionno” to 60200 as shown above.
- If you try to open the “Demo Database NAV (6-0)” with SP1 FinSQL then you will get the window regarding “Already converted”.
- To revert back to the original version from converted version. Go to SQL Server management studio and right click on “Demo Database NAV (6-0)” and select on “New Query” as shown above.
- Write the query and click on “Execute” as shown above.
- Note: Observe that “databaseversionno” as 150 as to convert the database to SP1 version.
- One row effected as shown above.
- Check whether “databaseversionno” updated to “150” by executing the above the command.
- Now try to open the “Demo Database NAV (6-0)” with SP1 FinSQL.
- “Demo Database NAV (6-0)” with SP1 FinSQL will be opened.
- Please refer this link as for your reference:
