Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

dynamics NAV data base archives

Posted on by

Hello allour structure have 2 NAV licence for 2 sites.

As we are a federal institution, we have now only 1 federal site. so our other site doesn't need to keep his licence except for archive consultation.

do you know a method to save all information in NAV data base ? just to give us the possibility to consult them (without NAV of course !

thanks a lot

regards

Patrick

*This post is locked for comments

  • Suggested answer
    keoma Profile Picture
    keoma 32,671 on at
    RE: dynamics NAV data base archives

    use odbc or ado.net to connect directly to and read data from the database. the database at the backend is a "normal" sql server database.

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: dynamics NAV data base archives

    You can export all the data to excel using dataports.

  • keoma Profile Picture
    keoma 32,671 on at
    RE: dynamics NAV data base archives

    http://www.dynamics.is/?p=658

  • RE: dynamics NAV data base archives

    Sorry but :

    - We don't want to upgrade this licence as it is obsolete (only used for archive consultations

    - We don't want to invest in developments.

    we really want to find a solution as an export from DB or something else ?

    thanks

    Patrick

  • keoma Profile Picture
    keoma 32,671 on at
    RE: dynamics NAV data base archives

    nav 5 is quite old. every software needs after some time an upgrade. so it would be a good idea to upgrade to nav 2009or 2013.

    for now you can try to use web services for nav 5.

    blogs.msdn.com/.../using-web-services-to-access-microsoft-dynamics-nav-5-0.aspx

  • RE: dynamics NAV data base archives

    YEs of course. Bu imagine that in a few years 3 ? 4? our DB becomes obsolete and can't be used /read from excel ? and we have to know the DB structure !

    thanks

  • Suggested answer
    keoma Profile Picture
    keoma 32,671 on at
    RE: dynamics NAV data base archives

    you can connect directly to the database using excel.

    but it would be better to buy another license.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans