Is Transfer Database task available in the DTS programming model

• msramanujam

  SSC Enthusiast

  Points: 108

  More actions

  January 28, 2005 at 7:39 am

  #88007

  I'm basically trying to copy an entire database from one server to another. I first tried the DETACH/ATTACH approach, but did not find it suitable for my requirement. The DTS approach is working fine for me and I used the "Transfer Database Task" from the SQL Server Enterprise Manager to accomplish this.

  I now need to duplicate the process using the DTS programming model. But I'm not sure if a DTS task object exists in the programming model for "Transfer Database Task".

  Can anyone confirm if a task object is present for "Transfer Database Task" in the programming model?

  TIA

  Jam

• January 31, 2005 at 8:00 am

  This was removed by the editor as SPAM

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  January 31, 2005 at 11:37 am

  #539775

  If you installed samples on SQL Server installation there are samples:

  C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSCopyDatabase

  Another way to run any DTS package from program or script - save package as file, then run with dtsrun utility.