NT4 TO W2K SQL

[livelonger]

I have a NT4 server running SQL 6.5. Not being overly familiar with SQL 6.5, my question is how can I migrate or upgrade SQL 6.5 to win2k server? Will I need to upgrade to SQL 7.0 or later, is there a SP for SQL 6.5 for win2k clients? I've already set win2k server

Thanks

 

[MAK9974]

You are bit confused.

NT can be upgraded to Windows 2000

SQL Server 6.5 can be upgraded either to 7.0 or directly to 2000.

SQL Server 6.5, 7.0 and 2000 will work on NT and windows 2000

 

[livelonger]

mak9974

Sorry for the confusion, I was wanting to know whether SQL 6.5 would work on Win2k and how I would tranfer the Database info from nt4 server to a new win2k server.

 

[tlbroadbent]

SQL 6.5 will run on Windows 2000. You need to apply service pack 5a. Check the following links.

http://www.microsoft.com/sql/techinfo/planning/win2kfaq.asp

http://support.microsoft.com/default.aspx?scid=KB;en-us;q197177

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[fluteplr]

The safest way to move the database(s) is to do a backup on the old server and a restore on the new server. You wil need to set up security on the new server.