Upgrading SQL Server 6.5 to 7.0


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Upgrading SQL Server 6.5 to 7.0

  1. #1
    blue Guest

    Upgrading SQL Server 6.5 to 7.0


    Hi,
    I've been using SQL 6.5 (SP3), and trying upgrade to SQL 7. I have SQL
    7 installed, and use the Upgrade Wizard to upgrade the database from 6.5
    to 7. I went through all the way until the error dialog box came up with
    "Preparing SQL-DMO for upgrade.out" file.
    Inside this file -- "The ODBC catalog stored procedures installed on
    server SUPBNHNSS697 are version 6.50.215; version 07.00.0523 or later is
    required to ensure proper operation. Please contact your system administrator.
    1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
    16> 17> 18> 19> 20> 21>
    1> 2> 1> 2> 1> 2> 3> 1> 2> 3> 4> 5> 6> 7> 8> Configuration
    option changed.
    Run the RECONFIGURE command to install.
    1> 2> 3> 4>
    Time established during sequence mode 1 before creates is '2001/02/22
    16:49:49' (spid=10, db=master)

    1> 2> 3> 4> 5> 6> 7> 8> 1> 2> 3> 4> 1> 2> 3> 4>
    1> 2> 3> 4> 1> 2> 3> 4> 1>
    2> 3> 4> 5> 6> 7> 8> 1> 2> 3> 4> 1> 2> 3> 4> 1>
    2> 3> 4> 1> 2> 3> 4> 1> 2>
    3> 4> 1> 2> 3> 4> 1> 2> 3> 4> 1> 2> 3> 4> 5> 1>
    2> 1> 2> 3> 4> 1> 2> 3> 4>
    1> 2> 3> 4> 1> 2> 3> 4> 1> 2> 1> 2> 3> 4> 1> 2>
    3> 4> 1> 2> 3> 4> 1> 2> 3>
    4> 1> 2> 1> 2> 3> 4> 1> 2> 3> 4> 1> 2> 3> 1> 2>
    3> 4> 5> 6> 7> 8> 9> 1> 2>
    3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4>
    5> 6> 7> 1> 2> 3> 4> 5> 6>
    7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1>
    2> 3> 4> 5> 6> 7> 1> 2> 3>
    4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5>
    6> 7> 1> 2> 3> 4> 5> 6> 7>
    1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2>
    3> 4> 5> 6> 7> 1> 2> 3> 4>
    5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> creating
    table spt_datatype_info_ext
    1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
    16> 17> 18> 1> 2> 3> 4>
    5> 6> 7> 8> 9> 10> 11> 1> 2> 3> 1> 2> 3> 4> 5>
    6> 7> 8> 9> 10> 11> 12> 13>
    14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27>
    28> 29> 30> 31> 32>
    33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46>
    47> (1 row affected)
    (1 row affected)
    (1 row affected)
    (1 row affected)
    (1 row affected)
    (1 row affected)
    (1 row affected)
    (1 row affected)
    1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>

    Warning:
    you are installing the stored procedures
    on a pre 7.0 SQL Server.
    Ignore the following errors.
    1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
    16> 17> 18> Msg 207, Level
    16, State 2, Server SUPBNHNSS697, Procedure , Line 13
    [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
    'xusertype'.
    1> 2> 3> 1> 2> 3> creating table spt_datatype_info"

    Any idea to help? Besides, can you tell me whether the upgrade will
    affect the web access to the databases? If so, how to prevent the problem?


    Thank you.


  2. #2
    Mike Guest

    Re: Upgrading SQL Server 6.5 to 7.0


    Make sure your 6.5 has the latest service pack from microsoft before running
    the sql7 upgrade.

    Web access will be determind by the users and roles setup in sql 7, you will
    have to re-establish these after the upgrade.


    "blue" <bluesl@1fssg.usmc.mil> wrote:
    >
    >Hi,
    > I've been using SQL 6.5 (SP3), and trying upgrade to SQL 7. I have

    SQL
    >7 installed, and use the Upgrade Wizard to upgrade the database from 6.5
    >to 7. I went through all the way until the error dialog box came up with
    >"Preparing SQL-DMO for upgrade.out" file.
    > Inside this file -- "The ODBC catalog stored procedures installed on
    >server SUPBNHNSS697 are version 6.50.215; version 07.00.0523 or later is
    >required to ensure proper operation. Please contact your system administrator.
    >1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
    >16> 17> 18> 19> 20> 21>
    >1> 2> 1> 2> 1> 2> 3> 1> 2> 3> 4> 5> 6> 7> 8> Configuration
    >option changed.
    >Run the RECONFIGURE command to install.
    >1> 2> 3> 4>
    >Time established during sequence mode 1 before creates is '2001/02/22
    >16:49:49' (spid=10, db=master)
    >
    >1> 2> 3> 4> 5> 6> 7> 8> 1> 2> 3> 4> 1> 2> 3> 4>
    >1> 2> 3> 4> 1> 2> 3> 4> 1>
    >2> 3> 4> 5> 6> 7> 8> 1> 2> 3> 4> 1> 2> 3> 4> 1>
    >2> 3> 4> 1> 2> 3> 4> 1> 2>
    >3> 4> 1> 2> 3> 4> 1> 2> 3> 4> 1> 2> 3> 4> 5> 1>
    >2> 1> 2> 3> 4> 1> 2> 3> 4>
    >1> 2> 3> 4> 1> 2> 3> 4> 1> 2> 1> 2> 3> 4> 1> 2>
    >3> 4> 1> 2> 3> 4> 1> 2> 3>
    >4> 1> 2> 1> 2> 3> 4> 1> 2> 3> 4> 1> 2> 3> 1> 2>
    >3> 4> 5> 6> 7> 8> 9> 1> 2>
    >3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4>
    >5> 6> 7> 1> 2> 3> 4> 5> 6>
    >7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1>
    >2> 3> 4> 5> 6> 7> 1> 2> 3>
    >4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5>
    >6> 7> 1> 2> 3> 4> 5> 6> 7>
    >1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2>
    >3> 4> 5> 6> 7> 1> 2> 3> 4>
    >5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> creating
    >table spt_datatype_info_ext
    >1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
    >16> 17> 18> 1> 2> 3> 4>
    >5> 6> 7> 8> 9> 10> 11> 1> 2> 3> 1> 2> 3> 4> 5>
    >6> 7> 8> 9> 10> 11> 12> 13>
    >14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27>
    >28> 29> 30> 31> 32>
    >33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46>
    >47> (1 row affected)
    >(1 row affected)
    >(1 row affected)
    >(1 row affected)
    >(1 row affected)
    >(1 row affected)
    >(1 row affected)
    >(1 row affected)
    >1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
    >
    >Warning:
    >you are installing the stored procedures
    >on a pre 7.0 SQL Server.
    >Ignore the following errors.
    >1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15>
    >16> 17> 18> Msg 207, Level
    >16, State 2, Server SUPBNHNSS697, Procedure , Line 13
    >[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
    >'xusertype'.
    >1> 2> 3> 1> 2> 3> creating table spt_datatype_info"
    >
    > Any idea to help? Besides, can you tell me whether the upgrade will
    >affect the web access to the databases? If so, how to prevent the problem?
    >
    >
    >Thank you.
    >



  3. #3
    P. Starkey Guest

    Re: Upgrading SQL Server 6.5 to 7.0


    I did not have to recreate logins after upgrading but be aware that upgrading
    to 7.0 still keeps the 6.5 ruleset in place unless you change the database
    compatibility level use sp_dbcmplevel and set the level to 70. This old
    ruleset is used to make sure you don't get any unexpected results until you
    can upgrade your apps to take advantage of the 7.0 ruleset. For a complete
    list of rule changes, go here

    http://msdn.microsoft.com/library/ps...da-di_5c8c.htm


    "Mike" <mscaife@infopower.co.nz> wrote:
    >
    >Make sure your 6.5 has the latest service pack from microsoft before running
    >the sql7 upgrade.
    >
    >Web access will be determind by the users and roles setup in sql 7, you

    will
    >have to re-establish these after the upgrade.
    >
    >
    >"blue" <bluesl@1fssg.usmc.mil> wrote:
    >>
    >>Hi,
    >> I've been using SQL 6.5 (SP3), and trying upgrade to SQL 7. I have

    >SQL
    >>7 installed, and use the Upgrade Wizard to upgrade the database from 6.5
    >>to 7. I went through all the way until the error dialog box came up with
    >>"Preparing SQL-DMO for upgrade.out" file.
    >> Inside this file -- "The ODBC catalog stored procedures installed

    on
    >>



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center