Navision 4.0 to navision 3.7

aniruddha_majumdaraniruddha_majumdar Member Posts: 57
edited 2005-09-02 in Navision Attain
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

Thanks & Regards,


  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262

    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.
  • pdjpdj Member Posts: 643
    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.)
  • HalMdyHalMdy Member Posts: 429
    The trick already exists in the concerning forum, see
Sign In or Register to comment.