Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 SQL Server 6.5 on Win2K Server

Author  Topic 

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-19 : 10:00:47
Yeah, Yeah, I know...

But I was asked, and have no idea (and hope I never have to have any experience)

I was hoping my 6.5 days were Loooooooooooong behind me....guess not

I'm working on explaining that an upgrade is a better solution....

Anyone have any war stories?

Is it possible (please say no)


Brett

8-)

nr
SQLTeam MVY

12543 Posts

Posted - 2004-02-19 : 11:21:26
Have a look at
http://support.microsoft.com/default.aspx?scid=fh;en-us;obsoletesrvr


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-19 : 11:33:30
quote:
Originally posted by nr

Have a look at
http://support.microsoft.com/default.aspx?scid=fh;en-us;obsoletesrvr


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.



Yeah thanks...I actually have that page bookmarked....

More ammo....

Ever do a 6.5 2k conversion?


I'm Looking at

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/upgrdmigrate/sqlugrd.asp

But I figure the best way might to bcp out, script and try and compile, fix bugs, bcp in...

And lots of testing...




Brett

8-)
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2004-02-19 : 20:32:20
Do a test upgrade to v7 - that highlights a lot of problems - keywords etc. after fixing those you can use your suggested method.

There are a few nasties in the ways queries work but you will find them.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-02-20 : 12:39:48
SQL Server 6.5 runs fine on Windows 2000, but you have to have service pack 5a installed for it to work. Other than that, you should be fine.

But upgrade it to SQL 2000!

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-20 : 14:32:59
Especially since 6.5 stop being supported at the end of 2002!

I think I've convinced "management"



Brett

8-)
Go to Top of Page
   

- Advertisement -