Client technical upgrade from Update 2 to Update 6

ta5
ta5 Member Posts: 1,164
edited 2007-12-10 in SQL General
Hi
We have a Navision 4.03 with SQL Server 2005. The clients are patched with Update 2.

As far as I understand, it is quite a good idea to upgrade the clients to Update 6 and turn of the IndexHinting.

What is the proper way to upgrade the clients to Update 6, i.e. do we need to create a new DB with a new client and apply a backup, or is it just about to fix the clients?

Many thanks in advance.
Thomas

Answers

  • DenSter
    DenSter Member Posts: 8,307
    You update the clients and when you open the database it will ask you to convert. You have to do this off hours though, since it's going to rebuild the indexes. You might even want to set the database to single user. I would do it on a test server first, to get an idea of how much time it takes to convert the database.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ta5
    ta5 Member Posts: 1,164
    Thanks a ton.
    So no backup, then new database, restore is needed, isn't it?
  • DenSter
    DenSter Member Posts: 8,307
    No I don't believe it is needed for this task. Taking a backup before you do it is always a good idea though, and I'd test it out on a copy of the database first.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ta5
    ta5 Member Posts: 1,164
    Hi Daniel
    Thanks a lot.
    Regards
    Thomas

Categories