command line generates different output for same project

sapp

When generating a difference for 2 schemas - either snapshot to snapshot or snapshot to database - I am getting different results between the GUI interface and the command line.

There are no error reported in either interface.

Here the output from the command line when ran -
Schema Compare for Oracle Command Line V1.5.0.126
==============================================================================
Copyright c 2009 - 2010 Red Gate Software Ltd

Reading dependency information
Registering database one
Registering database two
Comparing databases
Generating report
Finished

Command used :
sco /pr:"C:\Users\Documents\Schema Compare for Oracle\Projects\MODEL.ocp" /r:"C:\TEMP\snapshot.html" /rt:Interactive

sapp

The issue is that everything comes up as IDENTICAL vs via the GUI with 762 different , 67 create and 463 drop.

I am running on Windows 7 Pro 64 bit SP 1. When try pointing the command line to 32 bit libraries , it fails with :
Schema Compare for Oracle Command Line V1.5.0.126
==============================================================================
Copyright c 2009 - 2010 Red Gate Software Ltd

Reading dependency information
Error: ORA-12557: TNS:protocol adapter not loadable
Error: Comparison failed
Finished

The TNSEntries between the Oracle Homes are identical. Have tried with TNS_ADMIN set as well.

Tom Harris

Hi there,

it turned out that you need to include the additional switch to the command line.

/reportAllObjectsWithDifferences (Alias: /rad)
Includes all objects with differences in the reports, rather than all
selected objects.

Once this was added the reports worked correctly.

-Tom

Tom Harris, Red Gate Software