Upgrading SQL Server 6.5 to 7.0

[blue]

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.

[Mike]

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.
>

[P. Starkey]

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
>>