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.
| Author |
Topic |
|
MaverickUK
Yak Posting Veteran
89 Posts |
 Posted - 2003-05-07 : 05:11:25
|
| Hi guysForum lucker and part time poster here again.I thought I'd ask this, just to see if anyone has experience on such a matter.I've been given an SQL Server 6.5 database backup to use on a project, which I'll need to upgrade to an SQL Server 2000 db.However SQL 2000 can't directly import 6.5 data, so I've installed SQL Server 6.5 in the hope I'd be able to upgrade that to SQL 2000 and maintain the current database.When I tried to installed SQL 2000 it didn't seem to want to install itself and mentioned that SP5 for SQL 6.5 would be needed.I'm attempting to track down a copy, but not being on broadband it's a little harder than you might think.So my question basically is, I'm running WinXP Pro with SQL 6.5 installed, if I install SP5 for SQL 6.5 will I be able to upgrade to SQL 2000 and upgrade the database?Thanks |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-07 : 05:29:51
|
| Hi Maverick.Yes, you need SQL 6.5 SP5 in order to upgrade to an SQL2000 instance on the same server.Actually, I would recommend you to read this document, which is quite detailed about upgrades:[url]http://www.microsoft.com/sql/howtobuy/Upgrade_to_SQL_Server_2000.doc[/url] |
 |
|
|
MaverickUK
Yak Posting Veteran
89 Posts |
Posted - 2003-05-07 : 05:45:36
|
| Thanks Andraax |
|
|
|
|
|
|
SQL 6.5 remember that? ; ) & SQL 2000