Results 1 to 4 of 4

Thread: Copy SQL Server Objects Task ?

  1. 06-15-2005, 10:02 AM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    Question Copy SQL Server Objects Task ?

    My goal is need to synch couple of tables in QA and Prod. I used "Copy SQL Server Objects Task" in DTS package with copy option "replace existing data". It is trying to truncate and insert new data. But BOL is says "Overwrite existing data in the destination objects with the new data from the specified source".
    Let me know your thought about this.
    Reply With Quote Reply With Quote
  2. 06-15-2005, 10:36 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    I always copy table that way, no problem for me.
    Reply With Quote Reply With Quote
  3. 06-15-2005, 12:31 PM #3
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231
    Rmaio,
    are sure you didn't have any RI for those tables?. Because I'm getting RI voilation because of truncation. My main question will it truncate and insert new value?. if we have identity column the how it will treate?.
    Reply With Quote Reply With Quote
  4. 06-15-2005, 01:07 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You need copy related tables together, and check 'include extened properties'.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules