How can we help you today? How can we help you today?

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

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



cs77
0

Comments

2 comments

Sort by
  • Dan_J
    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.


    Dan_J
    0
  • Eddie D
    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 D
    0

Add comment

Please sign in to leave a comment.