Upgrade SQL 6.5 to SQL 7.0

  • GivThx

    SSCommitted

    Points: 1758

    Hi, Everyone

    I have a question for U.

    I have one SQL6.5 box that has 2 applications on it. I want to upgrade. What is the best way to do it? I have one test box that has SQL7.0 installed. I read lots of upgrading papers but I want some ideas from fields.:-)))I want use 2 boxes for backup and upgrade.

    Thanks in advance..

    Jay

  • Andy Warren

    SSC Guru

    Points: 119676

    You've got two different things to test. One is the upgrade, the other is how your apps perform. It's been a while since we upgraded from 6.5, but the wizard did the work - pretty easy. I'd suggest restoring a backup onto a different machine, running the upgrade to see how it goes. You want to be very familiar with the process, amount of time required, etc, before you do the real upgrade.

    Once you've upgraded the text server to 7.0 (or 2000 if you can manage it), then test your apps. If they are internal I recommend you get your develop team involved. Either way someone needs to come up with a list of core tasks you can test to make sure everything works. Only issue we found was a minor bit of code that did concatenation (behavior changed in 7 so that nulls propagate). Setting the dbcompatibility back to 6.5 is an easy fix until you have time to fix the problem. For legacy apps that you CANT fix you can just leave in 6.5 mode, take advantage of 7.0 features for other dbs.

    It's a lot of work, but well worth it!

    Andy

  • GivThx

    SSCommitted

    Points: 1758

    Thanks Andy...

    I will try and let U know...:-)))

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply