Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: SQL 6.5 TO SQL 2000 Upgrade

    What is the best way of brining a SQL Server 6.5 database to a Consolidated SQL Server 2000 environment? I tried using the SQL Server 2K upgrade wizard and it failed to import some data, which made me uncomfortable in using this tool?
    Is this a safe approach:

    Create a database on SQL 2K and script out all the objects like tables, Indexes, views and run it against SQL 2K.

    Then run the DTS to populate all the tables and you are done?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Perhaps...

    http://support.microsoft.com/default...;en-us;q261334

    There are some whitepapers out there
    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
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I had not heard of the upgrade tools not being able to bring over data. Do you remember the error details? The plan you have outlined will most likely work, except for a few gotchas on the stored procedures (check for "a = null" rather than "a is null"). For the most part, what you have outlined is exactly what the upgrade tools are doing.

    EDIT: Sniped!

  4. #4
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    Some of the tables have been brought over to the SQL2K but the data is missing. Don't really know why? Is there any reqt for the Upgrade tool like Service pack etc etc

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I believe you need SP5a for the SQL 6.5 side. But there should be no requirement for the SQL 2000 side.

Posting Permissions

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