Results Summary.csv already exists

Hi Everyone,
I'm currently running SQLDataCompare from the command line using the argfile switch.  In the xml file I'm using the <export> tag to capture data.  The problem is that I am frequently getting a fatal error with a 'Results Summary.csv already exists'  message.  I can't seem to get the /force option to work when using the argfile.  Any help is greatly appreciated.
Thanks,
Matt

Best Answer

  • adam_hafneradam_hafner Posts: 89 Silver 2

    Can you try adding the <force/> tag to your XML and see if that fixes your issue?  See the bolded text below...

    <?xml version="1.0" encoding="UTF-8"?>
    <span><commandline><br></span><span>&nbsp; <database1>database1</database1><br></span><span>&nbsp; <username1>username1</username1><br></span><span>&nbsp; <password1>password1</password1><br></span><span>&nbsp; <server1>server1</server1><br></span><span>&nbsp; <database2>database2</database2><br></span><span>&nbsp; <username2>username2</username2><br></span><span>&nbsp; <password2>password2</password2><br></span><span>&nbsp; <server2>server2</server2><br></span><span>&nbsp; <options>Default</options><br></span><span>&nbsp; <options>DisableAndReenableDDLTriggers</options><br></span><span>&nbsp; <options>DisableAndReenableDMLTriggers</options><br></span><span>&nbsp; <synchronize/><br></span><span>&nbsp; <include>Table</include><br></span><span>&nbsp; <include>Table:\[Yadda\]</include><br></span><span>&nbsp; <include>Table:\[Yadda1\]</include><br></span><span>&nbsp; <include>Table:\[Yadda2\]</include><br></span><span>&nbsp; <include>Table:\[Yadda3\]</include><br></span>&nbsp; &nbsp; <ExcludeColumns>Yadda3]$:Status</ExcludeColumns>

    <b><force/></b><br></commandline>

Answers

  • adam_hafneradam_hafner Posts: 89 Silver 2
    @mattkollar can you send me what  your command line looks with the argfile switch contents?  I have done some work like this so I could probably help if you could give me some additional details.
  • mattkollarmattkollar Posts: 3 New member
    Hi Adam,
    Thanks for your help.

    Here's a scrubbed excerpt of the xml file:
    <?xml version="1.0" encoding="UTF-8"?><br><commandline><br>&nbsp; <database1>database1</database1><br>&nbsp; <username1>username1</username1><br>&nbsp; <password1>password1</password1><br>&nbsp; <server1>server1</server1><br>&nbsp; <database2>database2</database2><br>&nbsp; <username2>username2</username2><br>&nbsp; <password2>password2</password2><br>&nbsp; <server2>server2</server2><br>&nbsp; <options>Default</options><br>&nbsp; <options>DisableAndReenableDDLTriggers</options><br>&nbsp; <options>DisableAndReenableDMLTriggers</options><br>&nbsp; <synchronize/><br>&nbsp; <include>Table</include><br>&nbsp; <include>Table:\[Yadda\]</include><br>&nbsp; <include>Table:\[Yadda1\]</include><br>&nbsp; <include>Table:\[Yadda2\]</include><br>&nbsp; <include>Table:\[Yadda3\]</include><br>&nbsp; &nbsp; <ExcludeColumns>Yadda3]$:Status</ExcludeColumns><br></commandline>Here's how I'm calling it from the command line:
    sqldatacompare.exe /verbose /argfile:example1.xml

  • mattkollarmattkollar Posts: 3 New member
    Adam,
    Looks like that did it.  Thanks!
    Matt
Sign In or Register to comment.