I'm all for progress but I miss the simplicity of 2000's DTS. All I want to
do is copy a source database to a destination along with that sources,
structure, data, indexes, relationships... It was a single dialog box with
some option buttons in 2000's DTS. Now, the Export function transfers only
structure and data but I can't seem to find options to send indexes, keys or
relationships.

Now I'm exploring the SSIS. The Transfer DataBase Task object looks easy
enough, but it wants a network share? And still, no sign of a way to transfer
the indexes...

Isn't there a wizard in SSIS that comes close to the full functionality of
the SQL 2000's DTS wizard?


--
Michael Hockstein

Hello,

I suggest that you refer to the following information:

Transfer Database Task
http://msdn2.microsoft.com/en-us/library/ms141204.aspx

*The database can be transferred by using online or offline mode. When you
use online mode, the database remains attached and it is transferred by
using SQL Management Object (SMO) to copy the database objects. When you
use offline mode, the database is detached, the database files are copied
or moved, and the database is attached at the destination after the
transfer finishes successfully. If the database is copied, it is
automatically reattached at the source if the copy is successful. In
offline mode, the database is copied more quickly, but the database is
unavailable to users during the transfer.

Offline mode requires that you specify the network file shares on the
source and destination servers that contain the database files. If the
folder is shared and can be accessed by the user, you can reference the
network share using the syntax \\computername\Program Files\myfolder\.
Otherwise, you must use the syntax \\computername\c$\Program
Files\myfolder\. To use the latter syntax, the user must have write access
to the source and destination network shares.*

To copy the index, you can use the "Transfer SQL Server Objects Task":

Transfer SQL Server Objects Task
http://msdn2.microsoft.com/en-us/library/ms142159.aspx

*Table Options
When copying tables, you can indicate the types of the table-related items
to include in the copy process. The following types of items can be copied:

" Indexes

" Triggers

" Full-text indexes

" Primary keys

" Foreign keys

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks Sophie

The Transfer SQL Server Objects Task seems to transfer data tables as well
as indexes... Why would I need to use both the Transfer Database Task and the
Transfer SQL Server Objects Task?

--
Michael Hockstein


"Sophie Guo [MSFT]" wrote:

Hello,

Please refer to the following information:

Transfer Database Task
http://msdn2.microsoft.com/en-us/library/ms141204.aspx

*The Transfer Database task transfers a SQL Server database between two
instances of SQL Server. In contrast to the other tasks that only transfer
SQL Server objects by copying them, the Transfer Database task can either
copy or move a database. The task can copy a database between instances of
SQL Server 2000, instances of SQL Server 2005, or one of each. This task
can also be used to copy a database within the same server.

The database can be transferred by using online or offline mode. When you
use online mode, the database remains attached and it is transferred by
using SQL Management Object (SMO) to copy the database objects. When you
use offline mode, the database is detached, the database files are copied
or moved, and the database is attached at the destination after the
transfer finishes successfully. If the database is copied, it is
automatically reattached at the source if the copy is successful. In
offline mode, the database is copied more quickly, but the database is
unavailable to users during the transfer. *

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.