Upgrade from 6.5 to 2000

Upgrade from 6.5 to 2000

Post by Craig Kornack » Fri, 13 Dec 2002 23:52:47



I'm looking for suggestions, tips, problem areas to look
for when upgrading from SQL Server 6.5 to SQL Server 2000.

Thanks.

 
 
 

Upgrade from 6.5 to 2000

Post by Catelin Wan » Sat, 14 Dec 2002 00:01:01


You may have to upgrade to SQL Server 7 first, then to SQL Server 2000.


Quote:> I'm looking for suggestions, tips, problem areas to look
> for when upgrading from SQL Server 6.5 to SQL Server 2000.

> Thanks.


 
 
 

Upgrade from 6.5 to 2000

Post by Oleg Deshi » Sat, 14 Dec 2002 00:05:02


Hi,

Consider this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;261334

Oleg.


Quote:> I'm looking for suggestions, tips, problem areas to look
> for when upgrading from SQL Server 6.5 to SQL Server 2000.

> Thanks.

 
 
 

Upgrade from 6.5 to 2000

Post by Mark Alliso » Sat, 14 Dec 2002 08:21:53


You don't need to go to 7 first. I prefer to do a two-box upgrade. Check
this link:
http://www.microsoft.com/sql/howtobuy/howtoup.asp

--
Mark Allison, SQL Server MVP
http://www.allisonmitchell.com


: You may have to upgrade to SQL Server 7 first, then to SQL Server 2000.
:


: > I'm looking for suggestions, tips, problem areas to look
: > for when upgrading from SQL Server 6.5 to SQL Server 2000.
: >
: > Thanks.
:
:

 
 
 

Upgrade from 6.5 to 2000

Post by Eric Yang [M » Wed, 18 Dec 2002 10:20:09


Hi Craig,

Please refer to the SQL 2000 online books about the topic 'Upgrading
Databases from SQL Server 6.5' for more information.

In addition, the following are some known issues about upgrade process. I
hope they could be of some help to you.

321456.KB.EN-US PRB: SQL 6.5 Upgrade Results in Errors 4850 and 4851
http://support.microsoft.com/default.aspx?scid=KB;EN-US;321456

302850.KB.EN-US PRB: Upgrade from SQL Server 6.5 Fails During "Import and
Export" Step
http://support.microsoft.com/default.aspx?scid=KB;EN-US;302850

291587.KB.EN-US BUG: SQL Server 6.5 Upgrade to SQL Server 2000 May Fail
When "Preparing
http://support.microsoft.com/default.aspx?scid=KB;EN-US;291587

Related web link:
=========
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
http://support.microsoft.com/default.aspx?scid=KB;EN-US;322620

Sincerely,

Eric Yang [MS]
Microsoft Support

Please do not send email directly to this alias.  This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

 
 
 

1. SQL Upgrade Wizard 6.5 to 2000 fails -- HELP!!

I get an error stating on an NT server box:
"Neither DSN nor SERVER keyword supplied. Invalid connection string
attribute"
And this msg comes up next:

Please make sure this value is not NULL."


computer is identical.
The error seems to come up after providing the 'sa' passwords and
selecting the export server.  The status box says "Restarting
MSSQLserver service" when the error occurs.
I have tried to reinstall 2000.

I cannot figure this out or find any information on it.
PLEASE HELP!!!

2. Trucating logs produces error message in log

3. OAS 4.X

4. Upgrading from 6.5 to 2000

5. How to add a new database ?

6. upgrade sqlserver 6.5 to 2000 hangs during preparing sql-dmo

7. 'LIKE' in DataEnvironment

8. Upgrading SQL 6.5 to 2000

9. procedure on how to upgrade from 6.5 to 2000

10. Upgrade from 6.5 to 2000

11. Upgrading from 6.5 to 2000