Results Summary.csv already exists
mattkollar
Posts: 3 New member
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: 91 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