January 31, 2005 at 12:57 am
Dear all
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
February 1, 2005 at 7:50 am
Jam,
Yes, it does exist. You can find code examples on the net quite easily. The MS website has some code too.
See DTS Package2 Hierarchy in Books Online.
P
February 20, 2005 at 11:42 pm
schleep,
Are you referring to the "TransferObjectsTask2" in the DTSPackage2 Hierarchy?
TIA
Jam
February 21, 2005 at 7:30 am
Yep. Choose All Objects and Data, and you're on your way.
P
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply