Posted by Erland Sommarskog on 03/01/07 22:21

(bob.ward@enron.com) writes:
> I attempted to upgrade to SQL Server 2000 from SQL Server 6.5 using
> the SQL Server Upgrade Wizard and I immediately received the following
> error message:
>
> An unknown error occurred while trying to restart your SQL Server
> 2000. Please check the server errorlog and try again.
>
> I've checked the SQL Server log and all of the logs available in the
> Event Viewer and I don't see anything remarkable in any of them. Does
> anyone have any suggestions for how to proceed?

It may be easier to run without the wizard. (I the days we migrated from
6.5, I never used the wizard myself.)

If you don't have the scripts for your databases under version control,
use the script-generation facility in the 6.5 Enterprise Manager. Then
run these scripts in SQL 2000.

For the data do:

SELECT 'bcp ' + db_name() + '..' + name + ' format ' + name +
'.bcp -n -U sa -P secretpw -S SERVER65 -f ' + name + '.fmt'
FROM sysobjects
WHERE type = 'U'
ORDER BY name

Run, save result in a BAT file and rnu BAT file. Change "format" to
out and run again, and again run result as BAT file.

SELECT 'bcp ' + db_name() + '..' + name + ' in ' + name +
'.bcp -n -E -U sa -P secretpw -S SERVER2000 -f ' + name + '.fmt'
FROM sysobjects
WHERE type = 'U'
ORDER BY name

Again run result as a BAT file.

Left to migrate is logins, users and permissions. This I don't have
anything canned for.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]