Client technical upgrade from Update 2 to Update 6

ta5

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

DenSter

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.

ta5

Thanks a ton.
So no backup, then new database, restore is needed, isn't it?

DenSter

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.

ta5

Hi Daniel
Thanks a lot.
Regards
Thomas