Results Summary.csv already exists

mattkollar

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

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

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

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

Adam,
Looks like that did it.  Thanks!
Matt