Options

CruiseControl + SQLDataCompare + NAnt + Regular Expressions

MsuiteMsuite Posts: 3
edited August 8, 2006 12:44PM in SQL Data Compare Previous Versions
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.
· Share on Twitter

Comments

  • Options
    MsuiteMsuite Posts: 3
    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.
    · Share on Twitter
This discussion has been closed.