Red Gate forums: Schema Compare for Oracle

RE: External authentication for schema compare

Michael Christofides — Mon, 17 Jun 2013 15:42:07 GMT

Hi,

Thanks for your message and apologies for the slow reply, this slipped under the radar.

You can connect manually and via TNS (using your TNSnames.ora file).

Are you referring to Windows authentication? Or perhaps OID?

We recently had a request for OID which I posted on our feature request forum: http://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/4017215-connect-via-oid

Best regards,
Michael

External authentication for schema compare

niceguy_reddy — Wed, 12 Jun 2013 17:51:52 GMT

Can we use external authentication to connect to a data base from Schema Compare for Oracle?

RE: Upgrade to Latest Version Breaks Schema Compare.

dhart — Tue, 11 Jun 2013 21:06:49 GMT

For some databases, Schema Compare just hangs on the postprocessing step of the compare with an insufficient memory to continue the execution of the program error. At this point Schema Compare has a memory usage (Private Working Set) of 3,859,200K. I'm thinking something is wrong

Do you want a memory dump?

RE: Upgrade to Latest Version Breaks Schema Compare.

neil.anderson — Tue, 11 Jun 2013 20:44:10 GMT

Hi Dave,

You can find a previous version here:

ftp://support.red-gate.com/patches/SchemaCompareforOracle/14May2013/SchemaCompareforOracle_3.0.0.542.exe

What error are you experiencing with the latest version?

Thanks,
Neil

Upgrade to Latest Version Breaks Schema Compare.

dhart — Tue, 11 Jun 2013 19:45:42 GMT

Comparing the databases hangs, until the application crashes. Schema compare is not usable is this state.

Is there a way to revert back to a previous version?

Thanks,
Dave

RE: schema compare and queue tables and queues

Michael Christofides — Mon, 20 May 2013 09:07:02 GMT

Hi Melissa,

Queues and queue tables aren't yet supported, how many of each do you have?

Here is our list of currently supported objects types:
https://documentation.red-gate.com/pages/viewpage.action?pageId=6750392

Are there any other object types you use not included there? If you could let us know the relative importance of each that would be very helpful.

Best regards,
Michael

schema compare and queue tables and queues

MelissaOlson — Fri, 17 May 2013 15:46:03 GMT

Hi,
Is there a way to set up my schema compare so that it will find my queues and queue tables?
Thanks!

RE: Missing comments on columns when comparing a schema

neil.anderson — Wed, 15 May 2013 10:19:44 GMT

Hi Luacap,

This has been included in Schema Compare 3.0.0.542 and Source Control 1.0.0.707.

Thanks,
Neil

RE: Drop and recreate same constraint on table

neil.anderson — Thu, 09 May 2013 14:26:59 GMT

Hi Jimmy,

Can you give me an example of this please? The DDL for the source and target table would help me recreate it.

Thanks,
Neil

RE: Drop and recreate same constraint on table

jimmywhc — Thu, 09 May 2013 09:07:41 GMT

FYI, I am using the trial version of 3.0

Drop and recreate same constraint on table

jimmywhc — Thu, 09 May 2013 09:06:52 GMT

I wonder why the schema compare will drop and recreate a constraint even though the constraints in source and target are the same.

Jimmy

RE: Existing Script compatibility

northtexasranch — Thu, 25 Apr 2013 22:39:53 GMT

Yes, I would like to hear about any workarounds that I could try!

Michael Christofides wrote:

Thank you for the comments. As you've noticed, this isn't supported, but there is a workaround that works in some cases. It depends on the current format of the files you have, but normally involves rearranging folder structures (to match ours) and adding empty xml files in specific places. If you're interested in trying it out let us know and we'll happily work through it with you.

RE: Existing Script compatibility

Michael Christofides — Thu, 25 Apr 2013 09:30:41 GMT

RE: Existing Script compatibility

northtexasranch — Wed, 24 Apr 2013 17:44:50 GMT

I recently downloaded v3.0 of Schema Compare for Oracle and I not only have existing DDL files that I would like to compare against, but also I rely on generating DDL from our data modeling tool. When I used to have a SQL Server target, using Schema Compare (for SQL Server) against DDL generated by that same tool worked like a charm, so I was hoping for the same experience on Oracle.

RE: Missing comments on columns when comparing a schema

Michael Christofides — Mon, 15 Apr 2013 09:01:45 GMT

I'm afraid we currently don�t compare table or column comments, but thanks for requesting it.

For anybody else interested in this feature, please vote for it here:
http://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/3845204