Specifiying tables in xml/command line utility

monkeygrind

If I run the following

<include>Table:TestKey$</include>
	<ignoremissing/>
	<ignoredifferent/>
	<synchronize/>

I get error (Nothing to compare). but if I take off the $

<include>Table:TestKey</include>
	<ignoremissing/>
	<ignoredifferent/>

I get the following:

Object type Name Records DB1 DB2

---

Table [dbo].[TestKey] 2 == ==

Isn't the $ simply supposed to represent and end in RegEx? Else I guess I could add excludes for tables with similar names like

<exclude>TestKeyLog</exclude>
<exclude>TestKey</exclude>

But I'm surprised the $ version isn't working, when previous posts suggest it would.

Dave Mellors

The last character of a table name is the ] character.

So if you used the following I believe it will work.
<include>Table:TestKey]$</include>

Please let me know how you get on.

monkeygrind

Got it now - was going off an example elsewhere on this forum.