command line generates different output for same project
sapp
Posts: 3
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
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
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.
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