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

Specifiying tables in xml/command line utility

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.
monkeygrind
0

Comments

2 comments

  • 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.
    Dave Mellors
    0
  • monkeygrind
    Got it now - was going off an example elsewhere on this forum.
    monkeygrind
    0

Add comment

Please sign in to leave a comment.