Compare just a single table via the command line

• 
  Hi Troy,
  
  I'm afraid your syntax is correct and this is a bug with SDC 9.0 (bug ref: SDC-1243). The /include switch doesn't seem to work.
  
  There are a few workarounds you could use for the time being:
  
  1) Create a project in the GUI, and then reference the project file using /project switch
  2) The /exclude switch still works, so you could exclude the tables you don't want.
  3) Downgrade to SQL Data Compare 8
  
  I hope this helps for now, and sorry for the inconvenience.
  
  Regards,
  
  Chris

  Chris Auckland August 03, 2011 04:29

  - 0 +
• 
  You could also try writing a negative regular expression for the /Exclude parameter as a workaround, e.g. exclude all except this table name string. I just had a bash at this but kept getting tripped up by reserved characters on the command line, so that might be fiddly to get right.
  
  Dan

  danere August 03, 2011 05:13

  - 0 +
• 

  Chris Auckland wrote:

  
  1) Create a project in the GUI, and then reference the project file using /project switch
  2) The /exclude switch still works, so you could exclude the tables you don't want.

  
  Unfortunately number 1 is throwing the same exception against this syntax: SQLDataCompare.exe /pr:MyCompareFile.sdc
  
  And number 2 would be rather unpleasant given the number of tables in the DB.
  
  Any word on the timeline for a fix?

  troyhunt August 05, 2011 01:32

  - 0 +
• 
  Hello Troy,
  
  Just to say that we've fixed the problem. We're just waiting on test resource before shipping you a private copy.
  
  Justin

  justin.caldicott August 05, 2011 04:57

  - 0 +
• 
  Can I just say: holy cow what a HUGE bug ... when can we get a fix? This totally blocks the new toolbelt release for us.

  Jaykul August 19, 2011 14:18

  - 0 +
• 
  There's now a patch release to fix this available from the below link:
  
  ftp://support.red-gate.com/patches/SQL_ ... 173469.exe
  
  HTH!
  
  Pete

  peter.peart August 23, 2011 11:26

  - 0 +
• 
  Beautiful, thanks Peter, the patched version is working just fine.

  troyhunt August 28, 2011 03:17

  - 0 +

Add comment

Please sign in to leave a comment.