How can we help you today? How can we help you today?

CruiseControl + SQLDataCompare + NAnt + Regular Expressions

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
0

Comments

1 comment

Sort by
  • 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.
    Msuite
    0

Add comment

Please sign in to leave a comment.