command line generates different output for same project

Compares and synchronizes the schemas of Oracle databases

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

command line generates different output for same project

Postby sapp » Mon Oct 24, 2011 8:33 pm

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
 
Posts: 2
Joined: Mon Oct 24, 2011 8:25 pm

continuing the description

Postby sapp » Mon Oct 24, 2011 8:43 pm

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.
sapp
 
Posts: 2
Joined: Mon Oct 24, 2011 8:25 pm

Postby Tom Harris » Fri Oct 28, 2011 2:51 pm

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
Tom Harris
 
Posts: 308
Joined: Wed Oct 06, 2004 3:45 pm


Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests