Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    11

    Unanswered: Upgrade to SQL Server 2000

    Hello,

    We've some of the boxes are SQL Server 7.0 with 65 compatability and SQL Server 7.0 with 70 compatability. Now we are planing to upgrade to SQL 2000 with 80 compatability.
    My question, how much complicated it is?
    Is there any code changes to do in Stored Procs or Triggers or other? and what are the differences?

    If lot of code changes, is there any tool to scan stored procedures?
    (As we've more 5000 Stored Procedures)

    If my question is not clear, let me know.

    Thanks!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'll be comiserating with you...

    I think I got one to do shortly

    http://support.microsoft.com/default...;en-us;Q322620
    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.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    My preference is to do a new build (new server, new O/S, new SQL install) and then move the databases (using DTS task, or manually generating the scripts and then puching the data over).

    Other than that preference, the rest can be summed up as Planning, Reviewing, testing, testing and more testing.

    Oh, and have a backout plan, too.

    Regards,

    hmscott

Posting Permissions

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