Schema Compare breaks on upgrade from 3.0.0.523 to 3.0.0.686

Compares and synchronizes the schemas of Oracle databases

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

Schema Compare breaks on upgrade from 3.0.0.523 to 3.0.0.686

Postby steve B » Tue Jul 23, 2013 2:33 pm

Bug Report:

Upgraded Schema Compare for Oracle breaks when comparing a database schema VS a script schema created by the old version.

Problem lies in the scripts within the UserObjectPrivileges folder - new version prefixes each object name in these scripts with the owning schema. Scripts created by the old version do NOT include the "schema." prefix before each object name - The missing prefix appears to be what breaks Schema Compare.
steve B
 
Posts: 4
Joined: Tue Jul 23, 2013 2:25 pm

Postby steve B » Tue Jul 23, 2013 3:42 pm

Bug Report:

Using Redgate Schema Compare 3.0.0.686 command line to rebuild database schemas from RedGate generated script files.
We rebuild multiple schemas in one pass - so have an automated run that builds each schema in turn, but logging on each time as the SYSTEM user (this worked fine in 3.0.0.542)
The schema build scripts generated by Schema Compare for Oracle 3.0.0.686 OMIT THE SCHEMA PREFIX FROM PACKAGE NAMES (in create package and create package body commands) - So when rebuilding the schemas, it attempts to create stored code within the current schema (i.e. SYSTEM)!!
So after the schema rebuild, we're left with multiple broken schemas that need to be patched up manually.
steve B
 
Posts: 4
Joined: Tue Jul 23, 2013 2:25 pm

Postby neil.anderson » Tue Jul 23, 2013 6:26 pm

Hi steve,

Thanks for the bug reports. I'll look into them asap. In the meantime you can revert to 3.0.0.542 using this link:

http://download.red-gate.com/checkforup ... .0.542.exe

Sorry for the inconvenience.

Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm

Postby steve B » Tue Jul 23, 2013 6:38 pm

Hi Neil,

We've currently got workarounds in place, as the capture of table and column comments in the new version outweighs the inconvenience of working around these 2 issues. But looking forward to seeing a version that captures comments AND is a little less buggy.

Thanks
Steve.
steve B
 
Posts: 4
Joined: Tue Jul 23, 2013 2:25 pm

Postby neil.anderson » Wed Jul 31, 2013 11:04 am

Hi Steve,

I cannot recreate the issue where SC is omitting the schema name from package names. How are you using the command line? Can you send me (oracle@red-gate.com) the project file if that is what you are using?

Does this occur all the time, even when you start afresh from the UI? Or is it just for certain objects?

Thanks,
Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm


Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests