| Author |
Message |
troyhunt
Joined: 28 Nov 2010
Posts: 15
Location: Australia
|
 Posted: Wed Aug 03, 2011 3:06 am Post subject: Compare just a single table via the command line |
 |
|
I'm struggling with something which should be very basic but I'm just not sure what I'm missing. I have two DBs from which I want to compare just a single table via the command line. I'm presently running this command:
SQLDataCompare.exe" /s1:(local) /db1:DB1 /s2:(local) /db2:DB2 /Include:table:\[MyTable\] /v
However, every common table in the DBs are compared (I think I'm probably misinterpreting the "include" switch as a whitelist). What am I missing here?
BTW, this is with the current version, 9.0.0.117 |
|
| Back to top |
|
 |
Chris Auckland
Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
|
| Posted: Wed Aug 03, 2011 9:29 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
danere
Joined: 12 Aug 2010
Posts: 3
Location: Sydney, Australia
|
| Posted: Wed Aug 03, 2011 10:13 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
troyhunt
Joined: 28 Nov 2010
Posts: 15
Location: Australia
|
| Posted: Fri Aug 05, 2011 6:32 am Post subject: Re: |
|
|
| 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? |
|
| Back to top |
|
|
justin.caldicott
Joined: 20 Apr 2011
Posts: 18
|
| Posted: Fri Aug 05, 2011 9:57 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
Jaykul
Joined: 19 Aug 2011
Posts: 1
|
| Posted: Fri Aug 19, 2011 7:18 pm Post subject: |
|
|
| 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. |
|
| Back to top |
|
|
peter.peartSite Admin
Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids
|
|
| Back to top |
|
|
troyhunt
Joined: 28 Nov 2010
Posts: 15
Location: Australia
|
| Posted: Sun Aug 28, 2011 8:17 am Post subject: |
|
|
| Beautiful, thanks Peter, the patched version is working just fine. |
|
| Back to top |
|
|
|
