Will the transfer manager copy all of the tables, etc from
one db to another empty db? If so, does all of the source
db info remain intact and able to be used as it was
previous to the transfer?

In article <0e5d01c377d5$5ba957f0$a601280a (AT) phx (DOT) gbl>, Steve Lee
<steve.lee (AT) seibels (DOT) com> writes
Yes.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hi Steve,

Thanks for Darren's help. I agree with him. Also, I'm including some
supplemental information below:

In SQL Server 6.5, SQL Enterprise Manager includes a transfer management
interface that can be used to transfer all or some objects from one
database to another. The destination server must be Microsoft SQL Server
version 6.5. The source server can be Microsoft SQL Server version 6.x or
4.x, or a server that is running a SYBASE System 10 server.
With the transfer management interface you can:

Copy all or some types of objects.
Copy all or some objects of a specific type.
Transfer schema and data, only schema, or only data.
Append or replace existing data.
Drop destination objects before copying schema.
Include dependent objects of a transferred object.
Use default scripting options, or customize the scripts that are used to
copy objects and security information.
Execute a transfer immediately, or schedule it to execute one time or on a
recurring basis.

The SQL Transfer Manager application is obsolete and is not provided in SQL
Server 6.5.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.