Upgrade sql server

akman
akman Member Posts: 67
edited 2008-09-17 in SQL General
Hello.

I have navision 4 running on sql 2000. I want sql 2005. Do I have to do something special or I just:

1. Backup NAV DB.
2. Uninstall sql 2000.
3. Install sql 2005.
4. Restore the NAV backup in a new DB on sql 2005.

What about sql 2008?

Thanks.

Answers

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Technicaly yes.

    In reallity no.

    The query optimiser works differently on SQL2005 and can have unexpected results.

    To have the least chance of suffering you want to be on the latest executable version of 4.0 SP3. This is IMHO the better version compared to 5.0 SP1 because of the tuning possibilities.

    SQL 2008 works. (I use it myself) but there are no real life experiences with the product.

    When SQL2005 was released it was promised heaven in terms of performance. I have heard MS sales say the same of SQL2008. SQL2005 was a complete drama in reality. (See Mibuso statistics).

    Good luck on making decisions.
    Marije Brummel | Freelance Business Central Specialist
  • akman
    akman Member Posts: 67
    Thanks for your answer.
    Mark Brummel wrote:
    The query optimiser works differently on SQL2005 and can have unexpected results.
    By unexpected results you mean speed issues or other problems too?

    So if I must go to sql 2005 you suggest first to upgrade to NAV sp3 and after that follow the steps I described at my first message? Can I be sure this way?
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    The issues are speed issues.

    The upgrade I am talking about is replacing the runtime, not a full upgrade.
    Marije Brummel | Freelance Business Central Specialist
  • akman
    akman Member Posts: 67
    You mean just install to all computers the SP3 client (replace the old installation) and then open the DB with one of them to convert it?
    Is it safe?
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    There are some things to consider like dll's and external interfaces that need to be tested. We've also experienced minor different behaviour between versions but I cannot recall an example from the top of my head.

    Before the convert, make a backup.

    Then TEST TEST TEST TEST
    Marije Brummel | Freelance Business Central Specialist
  • akman
    akman Member Posts: 67
    Dll's and external interfaces?
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Yes, stuff like outlook and excel integration. Biztalk etc.
    Marije Brummel | Freelance Business Central Specialist
  • akman
    akman Member Posts: 67
    Thank you very much for your help!
  • David_Singleton
    David_Singleton Member Posts: 5,479
    A client has one of their subsidiaries that had been running for over a year with no problems. Then a couple of weeks ago they moved the database to a different server. Exactly identical, no changes, but all of a sudden Navision is continuously blocking and very slow.

    In a casual discussion yesterday they mentioned that the only thing they can think of that they changed was that they moved form SQL 2000 to SQL 2005, but assumed that 2005 would be faster, so did not expect that to be the reason.

    So the first thing I am going to check is SQL 2005.

    What I have seen so far is that SQL 2005 works great, BUT it is different, and definitely tunning in 2005 is more important than in 2000.
    David Singleton

Categories