What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    adam_hafneradam_hafner Posts: 47 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

  • Options
    @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.
  • Options
    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

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