Exporting from DESKTOP to SERVER 
Author Message
 Exporting from DESKTOP to SERVER
Hi, I have developed a DB on SQLServer7 DESKTOP and now want to move it to a
SERVER.

If I use DTS to Export then I get a message saying "The license for the
installation of MSSQLServer on your source and destination does not permit
the use of DTS"

So how do I move my db from my Desktop machine to my Server?



Tue, 03 Dec 2002 03:00:00 GMT
 Exporting from DESKTOP to SERVER

Your best bet is to copy the database files (mdf, ldf, ndf (if any)) from
machine to the other.  You can detach then attach the files using
sp_detach_db and sp_attach_db.


Tue, 03 Dec 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Exporting from DESKTOP to SERVER

2. Exporting from DESKTOP to SERVER

3. DTS Export/Import Wizards: Server 7.0 to Desktop 7.0

4. import/export with sql7 DESKTOP ???

5. SQL Server 7 and SQL Server 2000 Desktop Engine named instance on same server

6. SQL Server CE without SQL Server on Desktop

7. Licensing problems with sql server and sql server desktop

8. Olap Server and SQL Server 7 Desktop?

9. Upgrading Sql Server Desktop engine to Sql Server 2000

10. VB Desktop Application Accessing SQL Server on Web Server

11. Olap desktop Client Cannot Connect To Another Desktop Olap Services

12. DTS Export: How to have nulls export as blanks on fixed width export


 
Powered by phpBB® Forum Software