Navision 4.0 to navision 3.7

aniruddha_majumdar
aniruddha_majumdar
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

Aniruddha
Thanks & Regards,
Aniruddha

Comments

  • Marije_Brummel
    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.
    Marije Brummel | Freelance Business Central Specialist
  • pdj
    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.)
    Regards
    Peter
  • HalMdy
    HalMdy
    The trick already exists in the concerning forum, see

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

Categories