CruiseControl + SQLDataCompare + NAnt + Regular Expressions

MsuiteMsuite Posts: 3

I'm trying to use the following regular expession to include multiple tables. I have cruise control passing in the following regular expression to NAnt which in turn runs sqldatacompare with the /include switch and the same regular expression.

[From the cruisecontrol config]

The problem is that sqldatacompare is only matching the last table in our regular expression.

Any suggestions would be appreciated, thanks.


  • Apparently what was wrong was the syntax that I used for the regular expression. When running SQLDataCompare normally on the command line one has to escape '|' with '^', but when using NAnt's exec task the '^' escape is not necessary and in fact, if used, will only match the last object listed for comparison.

    Hope this helps someone.
This discussion has been closed.