CruiseControl + SQLDataCompare + NAnt + Regular Expressions

Msuite

Hello,

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]
-D:inObjectsToCompare=\bTable1\b^|\bTable2\b^|\bTablen\b

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

Any suggestions would be appreciated, thanks.

Msuite

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.