Upgrading from 6.5 to 2000

Upgrading from 6.5 to 2000

Post by Ronnie James DI » Tue, 25 Sep 2001 22:53:59



Hi there,
I have a 2 GB of data and 2 GB of log based database on SQL Server 6.5 and I
get the backup of the *.dat files.
I've searched it up but is there any other way to restore a database backup
that have been taken with 6.5 to SQL Server 2000 without installing it
again.
Server ise Win 2000 Advanced Server with SQL 2000 installed.
Would there be any problems if I install 6.5 over SQL 2000? I know that
there are lots of problems that I can face in uninstalling 6.5...

Because of the telephony lines, these servers can't be in the same network
and the amount of data is incredible to be transferred over remote network.
All I can do is plugging the backup hard disk out of server and pull it in
the W2K-Adv server. And there are ony bakup dats in there.

thanks indeed.
dio

 
 
 

Upgrading from 6.5 to 2000

Post by Andrew J. Kell » Tue, 25 Sep 2001 23:15:17


You can not use a backup file from 6.5 to import or upgrade to 7.0 or 2000.
Take a look here for how to upgrade.
http://www.microsoft.com/sql/howtobuy/upgrading/howtoup.asp

--
Andrew J. Kelly,   SQL Server MVP



Quote:> Hi there,
> I have a 2 GB of data and 2 GB of log based database on SQL Server 6.5 and
I
> get the backup of the *.dat files.
> I've searched it up but is there any other way to restore a database
backup
> that have been taken with 6.5 to SQL Server 2000 without installing it
> again.
> Server ise Win 2000 Advanced Server with SQL 2000 installed.
> Would there be any problems if I install 6.5 over SQL 2000? I know that
> there are lots of problems that I can face in uninstalling 6.5...

> Because of the telephony lines, these servers can't be in the same network
> and the amount of data is incredible to be transferred over remote
network.
> All I can do is plugging the backup hard disk out of server and pull it in
> the W2K-Adv server. And there are ony bakup dats in there.

> thanks indeed.
> dio


 
 
 

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. Create table question

3. upgrade from 6.5 to 2000

4. Postgresql table reloading

5. Upgrade from 6.5 to 2000

6. Navigating as ISAM (DBASE III) database

7. Upgrade from 6.5 to 2000 problem

8. ER diagrams

9. SQL Upgrade from 6.5 to 2000

10. Upgrading from 6.5 to 2000 - books?

11. Upgrade from 6.5 to 2000

12. Upgrade from 6.5 to 2000 (Anyone done it?)