<choose>
<when test="${runsql=='true'}" >
<echo message="comparing and syncing schema" />
<exec program="${sqlcompare.path}\sqlcompare.exe" failonerror="false" resultproperty="returncode" verbose="true" >
<arg value="/scripts1:${sql.scriptsourcepath}" />
<arg value="/database2:${sql.database}" />
<arg value="/server2:${sql.server}" />
<arg value="/username2:${sql.user}" />
<arg value="/password2:${sql.password}" />
<arg value="/sync" />
<arg value="/ScriptFile:${sql.syncfilename}" />
<arg value="/report:${sql.reportfilename}" />
<arg value="/ReportType:Simple" />
<arg value="/options:ForceColumnOrder,IgnoreUsers,IgnorePermissions,IgnoreWhiteSpace,IgnoreUserProperties,IgnoreCollations" />
