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

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
mattkollar
0

Comments

4 comments

Sort by
  • adam_hafner
    @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.
    adam_hafner
    0
  • mattkollar
    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

    mattkollar
    0
  • adam_hafner

    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>

    adam_hafner
    0
  • mattkollar
    Adam,
    Looks like that did it.  Thanks!
    Matt
    mattkollar
    0

Add comment

Please sign in to leave a comment.