Red Gate forums: Schema Compare for Oracle Beta

Beta Refresh of Schema Compare for Oracle now available!

alice.easey — Thu, 22 Apr 2010 16:33:22 GMT

We've just released a new build of the beta (1.0.0.814) for Schema Compare for Oracle, mainly bugfixes.

What's fixed?
* Fix for foreign keys on disabled indexes throwing a null ref exception
* Fix for tables with XML TYPE columns throwing a null ref exception
* Configure Sync Script page in the sync wizard now appears if you change a NULL column to a NOT NULL column
* Fix for VARCHAR2 columns declared with Character semantics having incorrect length
* New error handling dialog to allow users to email us the stacktrace and last run query results
* Small performance improvements
* Updates to the Options help text
* Minor UI fixes

You can download the latest build from here:
Schema Compare for Oracle

Feedback is always welcome. Please let us know what you think, which object types to support, which features you'd like to see, etc.

To give us feedback or sign up for notifications of updated releases, please visit http://www.red-gate.com/OracleSchemaCompareEAtrialfeedback

RE: Abort Compare

Simon C — Fri, 16 Apr 2010 08:51:24 GMT

Sorry it's not working for you... Would it be possible to send me (email link at bottom of this post) a query snapshot of the two databases? This can be obtained using the RedGate.Oracle.CreateQuerySnapshot program in the SCfO install directory. This contains the raw data that we read from the database & only contains schema information, and this'll help us find out what's going on very quickly

Abort Compare

bobbyinga — Thu, 15 Apr 2010 14:05:57 GMT

When trying to compare 2 schemas for the first time, when the software is Registering database one, Populating foreign keys, I receive object reference not set to an instance of an object and the compare halts.

I can change the schemas that I want it to compare but get the same error over and over.

There is no info in the event viewer on this error.

Turned on logging.. Log message reads:

Code:

10:10:45.976|Error |Engine Service |1 |:Exception in progress dialog
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.Oracle.ObjectModel.DatabaseFactory.p()
at RedGate.Oracle.ObjectModel.DatabaseFactory.Populate()
at RedGate.Oracle.ObjectModel.LivePopulator.Populate()
at RedGate.Oracle.ObjectModel.DatabasePopulationHelper.a(IPopulator , ICollection`1 )
at RedGate.Oracle.ObjectModel.DatabasePopulationHelper.PopulateDatabase1()
at RedGate.Shared.Controls.ProgressDialogEx.e()

[/code]

Beta release of Schema Compare for Oracle now available!

alice.easey — Thu, 15 Apr 2010 12:11:13 GMT

We're pleased to announce that the beta release of Schema Compare for Oracle is now available for download.

Schema Compare for Oracle

The beta is the last chance for you to give input, so please give it a go and let us know how you get on.

New options:
� Ignore case differences
� Ignore double quotes

New features:
� Synonyms supported
� Sequences supported
� Triggers supported
� New page in the sync wizard to allow the user to configure NOT NULL column values and to specify data type conversion functions
� More warnings added to advise the user of potential synchronization issues
� Structured online help system, replacing the existing release notes.

Bug fixes:
� Overall stability of product has been greatly improved by numerous bug fixes

For more detailed information, please see the release notes .

Feedback is always welcome. Please let us know what you think, which object types to support, which features you'd like to see, etc.

To give us feedback or sign up for notifications of updated releases, please visit http://www.red-gate.com/OracleSchemaCompareEAtrialfeedback

RE: Aborting Compare

Tom Harris — Fri, 09 Apr 2010 11:19:30 GMT

Hi there,

could you drop me an email to tom.harris at redgate.com and I will send you a more recent build that should fix this problem?

Thanks, Tom

RE: Crashes while registering first database

Tom Harris — Fri, 09 Apr 2010 11:18:14 GMT

Hi,

Jagen I've emailed you directly with a more recent build that should fix this problem

Thanks, Tom

Aborting Compare

awhite — Thu, 08 Apr 2010 21:47:29 GMT

Message received while comparing databases is "An item with the same key has already been added".

Crashes while registering first database

msjrao — Wed, 07 Apr 2010 21:39:13 GMT

After 40 minutes into registering. it crashes.
Error message :
unable to cast object of type System.DBNull to type Syste.string

RE: Trial Expired?

alice.easey — Tue, 06 Apr 2010 11:45:45 GMT

Hi sorry about the trial expiry problem.
We've fixed this now in the latest build, which you can download here.

Thanks,

Alice.

RE: Trial Expired?

paolohu — Thu, 01 Apr 2010 10:25:24 GMT

I downloaded that today and still get the message - I just installed over the old one - not sure if that matters

RE: Trial Expired?

Simon C — Thu, 01 Apr 2010 10:17:21 GMT

Which build are you running? The latest build is 1.0.0.691 and can be obtained here; this build expires on the 31st may

Trial Expired?

paolohu — Thu, 01 Apr 2010 09:15:47 GMT

So when I launch the application now it just tells me the trial has expired. But I also don't see an option to purchase it.

Any other options?

RE: problem: syncing table when name is same as synonym

alice.easey — Wed, 24 Mar 2010 12:02:19 GMT

Hi Mafujosh,

Thanks for your post.

We're implementing support for synonyms very soon - this work is currently scheduled for v1.

I'll keep you posted with any news on this upcoming release.

Alice.

Installing 32bit application on 64bit

kiwirob — Wed, 24 Mar 2010 06:30:42 GMT

It would be ideal if when installing on a 64bit OS if you could choose which version of the application to install.

The software I develop is 32bit and it uses 32bit Oracle drivers but I develop on Win 7 64bit.

problem: syncing table when name is same as synonym

mafujosh — Mon, 22 Mar 2010 17:15:45 GMT

fyi

(in version 1.0.0.691)

Maybe you have this already handled in a newer release, but in case you don't:

When I am syncing a missing table into my database, it errors with "ORA-00955: name is already used by an existing object", because a synonym of that same name already exists. Deleting the synonym manually fixes this error.

The expected behavior, I think, would be to include the synonyms in the comparison window and have it show that one 1 side it is a table, and the other a synonym, and syncing would delete one before copying from the other.