transfer database from one SQL Server 6.5 to another SQL Server 6.5 
Author Message
 transfer database from one SQL Server 6.5 to another SQL Server 6.5
Hello

Can someone tell me how I can transfer a database from one SQL Server 6.5 to
another SQL Server 6.5. I want to burn a CD containing the database.

Can this be done from within SQL Server 6.5 or will I need an external tool
that will do the trick for me ?

Many thanks for any reply.

Gabriel Lozano-Morn
Developer
LOBBY-DATA-BANK, div. of IMC bvba



Sun, 28 Apr 2002 03:00:00 GMT
 transfer database from one SQL Server 6.5 to another SQL Server 6.5


Quote:
> Hello

> Can someone tell me how I can transfer a database from one SQL Server 6.5
to
> another SQL Server 6.5. I want to burn a CD containing the database.

> Can this be done from within SQL Server 6.5 or will I need an external
tool
> that will do the trick for me ?

Have a look at the FAQ below for transferring methods
between SQL Servers.

If you want to take the database to the new server on CD
you can DUMP it on the hard disk and burn the files
(with an external tool) to the CD.

Depending on your needs you may want to use the database
directly on the removable media. If this is the case, have
a look at 6.5 Books Online under

Administrator's Companion
 Part 3 Devices, Databases, and drives
  Chapter 6 Managing Databases
   Using Databases on Removable Media

HTH
--
Gianluca Hotz
BackOffice MVP (SQL Server)
MCP SQL Server and MCP Windows
http://users.alphasys.it/ghotz
--
Q.  How do I transfer data between SQL Server databases / across servers?
(v1.2 1999.05.28)

A.  There are a variety of methods :-

1.  The fastest method for whole databases is to use the DUMP DATABASE and
LOAD DATABASE commands.  You need to make sure that the databases are the
same size and made up of the same segment fragments in the same order.  If
you do an sp_help_revdatabase on both this will allow you to check the
required DDL for this.  You can DUMP and LOAD from a local tape device and
transport the tape if you do not have a network connection.  (With SQL 7.0
the commands are BACKUP DATABASE and RESTORE DATABASE)

2.  If you only want tables/data you can use the SQL BCP.EXE tool.  This is
a command-line program and is fully doc'd in the books-online.  It works on
one table at a time and allows you to create a flat file on disk.

3.  For stored-procedures/views etc. there is an old command-line based tool
called DEFNCOPY.EXE that works like BCP.  It isn't used much these days
unless you still have SQL Server on OS/2 - though it still works on NT at
least up until 6.5.

4.  SQL Enterprise Manager comes with a built-in gui transfer function, and
SQL 7 comes with a separate, equivalent tool based on DTS.  This allows
transfer of all objects between two databases/servers but requires a network
connection between the two.

5.  The transfer tool supplied with SQL EM is exposed via the DMO interface
and can be called using the SQLOLE calls from TSQL or your own VB program
for automation purposes.  See Q152801 for an example of how to do this.

6.  3rd-party DBMS management tools no doubt offer similar/better
transfer/scripting tools to the above.



Sun, 28 Apr 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Transfer database from one SQL Server 6.5 to another SQL Server 6.5

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

3. Moving all databases from one SQL 6.5 server to another SQL 6.5 s erver

4. sql 6.5 logins and database permissions transfer from one server to another

5. Transferring SQL 6.5 data base to another SQL 6.5 Server

6. Transfering Data from one SQL 6.5 to antother SQL 6.5 server

7. SQL Server 6.5 transfer to SQL Server 7.0

8. Transfer data between SQL Server 6.5 to SQL Server 2000

9. How To Transfer From SQL Server 6.5 Server to 7.0 Server

10. Moving alerts from one server to another server in sql server 6.5

11. SQL Server 6.5 Transfer to New Server

12. Transfer database from SQL-Server 6.5 to Oracle ?


 
Powered by phpBB® Forum Software