Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Westlake Village, CA
    Posts
    6

    Smile Unanswered: Upgrading SQL 7.0 to SQL Server 2000

    Hi,
    I'm planning an upgrade of SQL 7.0 on NT 4.0 to SQL 2000 and of course I will attempt to upgrade the OS to Windows 2000 first.
    Can anyone tell me of any issues I may run across during this upgrade?
    Can I assume that SQL 7.0 will run ok on Windows 2000?

    thanks much,
    Robert

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734

    Re: Upgrading SQL 7.0 to SQL Server 2000

    Originally posted by rsalucci
    Hi,
    I'm planning an upgrade of SQL 7.0 on NT 4.0 to SQL 2000 and of course I will attempt to upgrade the OS to Windows 2000 first.
    Can anyone tell me of any issues I may run across during this upgrade?
    Can I assume that SQL 7.0 will run ok on Windows 2000?

    thanks much,
    Robert
    I've done several upgrades and haven't had any problems really. If you have a bunch of stupid Access databases connecting to your server, they will need to have an upgraded MDAC. You also need to read this document:

    compatibility issues, between SQL Server 2000 and SQL Server 7.0

    Copy and paste the above into Books Online and see what they have to say.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Jul 2003
    Location
    Westlake Village, CA
    Posts
    6

    SQL Upgrade

    Thanks Derrick, I'll check it out.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check out http://www.sqlteam.com/item.asp?ItemID=9066 article about Upgrade.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Jul 2003
    Location
    Westlake Village, CA
    Posts
    6

    SQL Upgrade

    Good stuff Satya, thanks.

    Robert

Posting Permissions

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