Archiving Navision Database (SQL Server Option)

Dhaneesha
Dhaneesha Member Posts: 62
edited 2014-06-24 in NAV/Navision Classic Client
Hi

Need your help concerning archiving a Navision database historical data (2009 R2) based upon Sql server.

What are the procedures to do such a process as the database has become quite bulky. (Even if the process can be carried out directly on sql server)

Thanks a lot in advance.

Comments

  • ssingla
    ssingla Member Posts: 2,973
    What do you mean by bulky?
    What data you want to archive?
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Dhaneesha
    Dhaneesha Member Posts: 62
    I want to archive data which exists for more than 3 years on the system, like for example sales header & line archive tables.
  • bbrown
    bbrown Member Posts: 3,268
    Why do you want to do this? What do you mean by "bulky"? Can you provide some details on what data you want to archive and what do you mean by "archive"?
    There are no bugs - only undocumented features.

Categories