Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: Upgrade 6.5 to 2000

    Hi,
    I'm looking to upgrade our old 6.5 server (running NT4) to 2000 and go to Windows Server 2003 at the same time. There are 10 or so small to medium sized DBs on here.
    Can anyone provide some decent links to blogs, FAQs or documentation relating to this?

    Many thanks,
    Matt

  2. #2
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95
    First port of call for anything SQL Server is most definately

    http://www.sqlteam.com/

    If it ain't there it ain't happened!

    What version of 2000 are you upgrading to?

    There is at least one bug in the upgrade process so test it first!!!!
    Sorry to be terse
    some say it's a curse
    I know it's worse
    I'm just diverse

  3. #3
    Join Date
    Mar 2004
    Posts
    4
    Thanks for that, I'm upgrading to 2000 Enterprise.

    Currently thinking of rebuilding the server on a completely new box running Windows Server 2003, upgrading SQL on a third box and then transferring SQL 2000 + data to the new.

  4. #4
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95
    2000 has a really neat wizard to import data from a different DB I suggest you try it.

    I would not worry about doing the upgrade before importing personally because it should in theory upgrade as you import!

    Ohhh remember to check all the DTS logins etc as they could get screwed up in translation...


    AND BEFORE ANYTHING -------- BACKUP and BACKUP the BACKUP
    Sorry to be terse
    some say it's a curse
    I know it's worse
    I'm just diverse

  5. #5
    Join Date
    Mar 2004
    Posts
    4
    The reason we are looking at upgrading before hand is we have hundreds of stored procs that need to be converted, replacing double quotes etc.
    Also we're looking at having as little downtime as possible.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you can afford the luxury of two machines, build a new machine with Windows 2003 and SQL 2000. Build scratch copies of all of your databases then script out the objects (tables, views, stored procedures, etc), and play those scripts into the new databases. Repeat that scripting process as necessary until you get it down to a repeatable process. Create one or more DTS packages to move the actual data from 6.5 to 2000. It actually goes surprisingly quickly if you go about it systematically.

    -PatP

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do what Pat said.

    One of our PROD DBA's used the upsizing wizard and it screwed up some DEFAULT Contraints.

    No one knew until I was asked to look into the "problem"
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    All this hype, and still missed the boat! THERE IS NO DIRECT UPGRADE PATH FROM 6.5 TO 2000!!! What are you all talking about?? If you want to use "the wizards" (wizard boy) then you need to upgrade to 7.0 first, and definitely not onto 2003!!!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ...but someday, my son, you will become a Wizard Man.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ...some day son...ALL of this will be yours....

    What? The curtains?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •