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