1

Using SQL Compare 10, I've created an .scp file which compares a local database (on the local build server) with what's in Source control (TFS via redgate SQL Source Control)

Using the GUI a number of differences are listed.

When running the .scp file from the command line, no differences are listed at all. - "The selected objects are identical or no objects have been selected in the comparison"

Command line is 

"C:\Program Files (x86)\Red Gate\SQL Compare 10\sqlcompare.exe" /project:"C:\Users\CIUser\Documents\SQL Compare\SharedProjects\MyDBName v MyDBName (Head).scp" /scriptfile:deploy_MyDBName.sql /include:identical /force

NB

The /include:/identical switch means the compare will not report an error if no changes are detected
The /force switch forces an overwrite of the sql script, rather than causing an error
Fetchez la vache
  • 4,940
  • 4
  • 36
  • 55

2 Answers2

8

OK, solved this, although it seems a little obtuse to me, to say the least.

Prior to saving the project file (or at least before running it from the command line) you need to:

a) You have to run the compare - BUT.. the comparison needs to pick up some differences

b) As it has picked up some differences, when the results are shown, in the heading row, you need to check the tickbox between the 2 "Object Name" columns, and then

c) save your project.

Though the project file is a text / XML file, doing the above steps adds some encrypted guff in the file, that seems to make it work - i.e it's not simply changing one of the xml values to True that was False.

Hope this helps someone... There must surely be a better way of fixing this...

Fetchez la vache
  • 4,940
  • 4
  • 36
  • 55
  • @KarelFrajták - Sorry I'm not going to be able to help with this - we dropped sql-compare shortly after I posted this. All the best. – Fetchez la vache Jan 06 '17 at 14:21
  • 1
    No worries, it was more like a rhetorical question :) – Karel Frajták Jan 07 '17 at 10:24
  • Thank you! You think this is what you need to do everytime you want to compare and get refreshed results or will it pick that up on its own? This is just a one-time setting? – Tigerjz32 Aug 13 '18 at 20:00
  • 1
    @Tigerjz32 I honestly couldn't say - we dropped sql compare soon after I posted this and that was in 2013. Sorry. I would hope things have changed for the better by now though, so good luck :) – Fetchez la vache Aug 14 '18 at 14:39
0

Had this same problem and was about to despair that the code i'd been working on was rendered useless, however I used the below switches to fix:

/include:Identical /ReportAllObjectsWithDifferences

Jims
  • 53
  • 1
  • 6