Manu,

DTS means Data Transformation Services, and is basically there to faciitate
the transfer of data, including the possibility of ETL (Extract
Transformation and Load) functionality during the data move process.
If the destination "bucket" isn't present DTS will script out the table and
apply it before trying to move the data. This allows a "DBA" to transfer
data without having to make sure the tables are there first. In a way it's a
nice to have as it alleviates some of the workload.

If a table has indexes or other constraints placed upon it, they need to be
transferred explicitly and DTS isn't responsible for this.
You will need to script out the table constraints, and isf you want, the
table itself, which is easy enough to do (right click and choose to generate
a CREATE statement), and also each of the indexes and constraints, which is
also easy and the same process (right click, choose script to CREATE
statement), remember that the script will also include the filegroup upon
which the table, the index, or the constraint is placed and will need to be
changed to whatever filegroup your "new" table exists on the destination
server.

Hope that helps.

Thanks,
Jeremy Greaves
Fenris Software Consulting, Inc



>From: "Manu Varghese "
><mssqldba-ezmlmshield-x31390839.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: DTS
>Date: Thu, 31 May 2007 06:55:26 -0700 (PDT)
>
>Hi
>
> I want to export two tables from one database to other,the table
>contain constraints and relationships.how can i transfer it with
>constraints and relationships.I used dts wizard but relationships and
>constraints are not coming.
>
>
> Regards
> Manu.
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



MS Sql Server LazyDBA home page