command line generates different output for same project

sappsapp Posts: 3
edited October 28, 2011 9:51AM in Schema Compare for Oracle
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

Comments

  • 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.
  • 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
Sign In or Register to comment.