Why does sqldatacompare /Exclude:Additional /Synchronize deletes data from target database

cs77cs77 Posts: 1 New member
in SQL Data Compare
sqldatacompare /Server1:sqlserv1 /db1:tmp /Server2:sqlserv1 /db2:tmpa /Include:table:Bottle /Exclude:Additional /Exclude:Identical /aow:Medium /ignoreParserErrors /Options:k,c,t,drd /warn /verbose  /Synchronize >>C:\TEMP1\outputSDC.txt 

It deletes the data in tmpa database that is not in tmp.  I thought that /Exclude:Additional would stop it from deleting data from the target database



Tagged:
· Share on Twitter

Answers

  • Dan_JDan_J Posts: 459 Silver 2
    Hi @cs77

    Thanks for reaching out to us regarding this.

    If possible, it would be useful to have a copy of the scripts folder of your source and target so that I can attempt to reproduce the issue you are seeing.  Of course, it isn't advisable to attach these to this public forum post and so I will email you from the ticket we have open for this issue, you should then be able to send your attachments in your reply.


    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    Hi cs77,
    Following the support ticket that was created for you.  I believe the problem you have reported here using V14.4.4.16824 has been resolved in a later version, V14.4.10.17174.

    The latest version of SQL Data Compare is Version 14.5.0.18430.

    I have updated the ticket and provided a download link where you can download V14.4.4.17174 and  V15.5.0.18430.  Please upgrade and confirm that the problem is resolved.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.