Navision 4.0 to navision 3.7

aniruddha_majumdar

Hi all,

Actually i cought into a postion where I require the members help.
The Problem is:

I mistakenly converted my Nav 3.7 database to 4.0.
How can now I open my 4.0 database in Nav 3.7 client.

Please I require the soln. immediatly

Aniruddha

Marije_Brummel

Aniruddha,

You cannot downgrade a database.

But maybe there is a trick:

Try exporting all objects to text and import them into a new 3.70 database

Make a backup of data only and restore this in the 3.70 db.

pdj

If Mark's method doesn't work I guess you can do it using SQL.

Make a complete backup and restore it into finsql4
Close the finsql4 client and open the db with the enterprise manager
Find the SQL system table containing the version. I can't remember the tablename, but I seem to remember that "15" is 3.70. (Search the forum or hope that anyone remembers, anyone?)
Well, simple change the value to the one fitting for the old version.
Then open the db in finsql3.70 and make a new backup.
Then restore that in you old db.

I have never tried it, but I guess it is possible...

(You could reduce the restore time a LOT by deleting all disabled keys and disable all non-primary keys in entry-tables. And then enable them when you have the final 3.70 version in the Navision 3.70 database.)

HalMdy

The trick already exists in the concerning forum, see

http://www.mibuso.com/forum/viewtopic.php?t=1544