SQL 7 to 2000 Upgrade Wizard ?

[FredWagner]

I'm upgrading a FileNet Document Services data store, and one of the steps required me to upgrade from SQL 7 to SQL 2000. I go the SQL 2000 Enterprise Edition CD's from our Net Admin folks, and at the appropriate point, ran the upgrade. SQL 7 still seems to be dominant, and there's an item in my start menu folders Called "MS SQL Server - Switch" with one Item, a SQL upgrade Wizard - which, when run, says its for SQL 6.5 to SQL 2000 migration. I tried to run it anyway, and it errored out, stating that the export server was not SQL 6.5.
Any suggestions where I might locate the correct Wizard for SQL 7 to 2000 upgrade? My SQLSERVR.exe size has changed, so now it's almost the same size as the SQLSERVR.exe on an another server I have that was originally installed with SQL 2000 server.

Fred Wagner
KQ6Q@arrl.net

 

[mrdenny]

There is no upgrade wizzard from SQL 7 to SQL 2000. It's a manual process.

Open enterprise manager and right click on the server and select properties. What version does it report? If it's 8.00.xxx then it's SQL 2000, if it's 7.xx.xxx then it's SQL 7.

Do your databases show up in Enterprise Manager?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[FredWagner]

It's showing 2000.80.194. It's a weird upgrade -the folders all still show SQL 7, even Add/Remove programs, if you start to remove SQL 2000, it says it's SQL 7. I can see the tables, even ran sp_updatestats on each of them successfully. The FileNet upgrade ran, produced a couple of minor errors, nothing catstrophic. I'll give it a fresh look on Monday.

Fred Wagner
KQ6Q@arrl.net

 

[mrdenny]

Try running

select @@VERSION

Post what it outputs. It may give us a better idea as to what you are running.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)