Migrating from SQL Server 2000 to SQL Server 7 
Author Message
 Migrating from SQL Server 2000 to SQL Server 7
Hi, it's me again, I have a customer who installed SQL
Server 2000 trial and begin using for the trial period,
but after it finished, the sql server service did not
startup again. He wishes to installed Sql Server 7 now,
but he wants to recover the databases that created with
SQL 2000. The Sql Server 2000 Trial is not working, waht
can I do? Do I install first a full version of Sql 2000
and then Sql 7? Any idea? Thanks a lot in advance


Tue, 17 Feb 2004 02:25:36 GMT
 Migrating from SQL Server 2000 to SQL Server 7

You cannot restore a SQL 2000 database to SQL 7.  I'd suggest getting SQL 2000 running again then using DTS or bcp to export the data to SQL 7.

HTH

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Tue, 17 Feb 2004 02:55:36 GMT
 Migrating from SQL Server 2000 to SQL Server 7
You can upgrade the eval copy to a full blown version and you should be able
to access the database in SS2K.  You can not use these databases in SQL7.0
directly, without getting these up on SS2K.

Vijay


Quote:
> Hi, it's me again, I have a customer who installed SQL
> Server 2000 trial and begin using for the trial period,
> but after it finished, the sql server service did not
> startup again. He wishes to installed Sql Server 7 now,
> but he wants to recover the databases that created with
> SQL 2000. The Sql Server 2000 Trial is not working, waht
> can I do? Do I install first a full version of Sql 2000
> and then Sql 7? Any idea? Thanks a lot in advance



Tue, 17 Feb 2004 07:30:14 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Migrate from Old SQL 2000 server to a New SQL 2000 server

2. Migrating an SQL Server 7.0 database to an SQL Server 2000

3. Migrate DTS from SQL Server 7 to SQL Server 2000

4. Downgrade / Migrate - SQL SERVER 2000 - SQL SERVER 7.0

5. Migrating from SQL Server 7.0 to SQL Server 2000

6. Migrating from SQL Server 7 to SQL Server 2000

7. Help - migrating from SQL 2000 desktop to SQL Server 7.0

8. Migrating a DB from SQL 7.0 to an SQL 2000 server

9. how to backup a sql server 65 server from a sql server 2000 server

10. Migrating queries in Access 2000 to SQL Server 2000

11. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

12. Connecting to a Sql Server 2000 SP3 from a Sql Server 2000 SP2


 
Powered by phpBB® Forum Software