Results Summary.csv already exists
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_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> <database1>database1</database1><br></span>
<span> <username1>username1</username1><br></span>
<span> <password1>password1</password1><br></span>
<span> <server1>server1</server1><br></span>
<span> <database2>database2</database2><br></span>
<span> <username2>username2</username2><br></span>
<span> <password2>password2</password2><br></span>
<span> <server2>server2</server2><br></span>
<span> <options>Default</options><br></span>
<span> <options>DisableAndReenableDDLTriggers</options><br></span>
<span> <options>DisableAndReenableDMLTriggers</options><br></span>
<span> <synchronize/><br></span>
<span> <include>Table</include><br></span>
<span> <include>Table:\[Yadda\]</include><br></span>
<span> <include>Table:\[Yadda1\]</include><br></span>
<span> <include>Table:\[Yadda2\]</include><br></span>
<span> <include>Table:\[Yadda3\]</include><br></span>
<ExcludeColumns>Yadda3]$:Status</ExcludeColumns>
<b><force/></b><br>
</commandline>
Answers
Thanks for your help.
Here's a scrubbed excerpt of the xml file:
<?xml version="1.0" encoding="UTF-8"?><br>
<commandline><br>
<database1>database1</database1><br>
<username1>username1</username1><br>
<password1>password1</password1><br>
<server1>server1</server1><br>
<database2>database2</database2><br>
<username2>username2</username2><br>
<password2>password2</password2><br>
<server2>server2</server2><br>
<options>Default</options><br>
<options>DisableAndReenableDDLTriggers</options><br>
<options>DisableAndReenableDMLTriggers</options><br>
<synchronize/><br>
<include>Table</include><br>
<include>Table:\[Yadda\]</include><br>
<include>Table:\[Yadda1\]</include><br>
<include>Table:\[Yadda2\]</include><br>
<include>Table:\[Yadda3\]</include><br>
<ExcludeColumns>Yadda3]$:Status</ExcludeColumns><br>
</commandline>
Here's how I'm calling it from the command line:Looks like that did it. Thanks!
Matt