Move Database from sql 6.5 to sql2000

[Antelope]

Since I cannot access my 6.5 SqL Server from my SqL 2000 Enterprise console, I need to move the databases over to the SQL 2000 server. What is the best way to do this? Do I have to at least upgrade the 6.5 server to 7.0 before I can even access it? If that is the case, can I just upgrade from 6.5 to 2000?

 

[cyno]

Hi Antelope,

You can restore the 6.5 database to Sql server 2000 server.

Thanks,
Cyno

 

[Antelope]

Great, thanks for your help. I felt like I was lost in a windows 3.1 world when I pulled up that 6.5 console (well, it really wasn't that bad, but not what I was used to).

 

[JayKusch]

Antelope.

Cyno was "partially correct" correct in saying you could get your DBs from 6.5 to 2000. You however have to go from 6.5 to 7.0 and then to 2000. You cannot go from 6.5 straight to 2000.

Same situation for upgrading to 2000. You will need to go from 6.5 to 7.0 then to 2000.

Thanks

J. Kusch

 

[Antelope]

So if I don't have a SQL 7.0 Server, I have to upgrade my 6.5 to 7.0, then back it up. Then I can restore it on a 2000 server?

 

[JayKusch]

Yes

Thanks

J. Kusch

 

[Antelope]

Hello again. Still working on this. Problem is I cannot find a SQL 7.0 disk to upgrade my SQL server from 6.5 to 7.0. I do, however, have another SQL server running 7.0. When I try to backup the database on 6.5 and restore it on 7.0, I get the following error:

The file on device d:\database.dat is not a valid Microsoft Tape Format Backup set.

So, It looks like I cannot backup a 6.5 database and restore it on a 7.0 server?

 

[JayKusch]

That is correct! You CANNOT restore a 6.5 backup file to a 7.0/2000 SQL Server instance. Completly different database structures especially w/ the transaction log.

You can however jump and upgrade of 6.5 straight to 2000 if you wish. This would bypass the intermediate step of upgrading first to 7.0 then to 2000.

I have always used the 6.5 to 7.0 to 2000 method myself though.

Thanks

J. Kusch