20 results found
-
When will Schema Compare support Oracle 12c?
Things like lack of support of JSON objects, default on null on columns statements, and table compression statements cause us to use script rather than moving through the tool. The tool works great for things that have full support and would love to be running everything through it.
46 votesRedgate tools for Oracle are now compatible with Oracle version 12c. Full 12c support for Schema Compare was released earlier this year.
-
Need the filter capability that SQL Compare currently has
SQL Compare allows the user to use a customized filter to exclude specific objects, object types, or objects with a certain named pattern.
This would be extremely useful in the Oracle tool as well.
39 votesIgnore Rules were implemented in v5.2 for Schema Compare, Data Compare, and Source Control for Oracle. More details can be found at https://documentation.red-gate.com/ddfo/other-resources/list-of-released-features. We hope this meets your needs and looking forward to hearing your feedback.
Thank you!
Stephanie Herr
Product Manager, Database DevOps -
Support for Queue Tables
Please add support or the ability to find Queue tables.
12 votesThis was released in V5.7.11
-
Support Table Type Columns
It appears that Schema Compare does not support table types as columns. I have a table that had a type type added to it on dev. I compared it with QA and it correctly detected the difference, however, the migration script did not include the storage clause necessary for deployment. The statement it created is this:
ALTER TABLE xxproduct.auditlog ADD (auditvalue xxproduct.auditvaluetab);
It should have created something along these lines:
ALTER TABLE xxproduct.auditlog ADD (auditvalue xxproduct.auditvaluetab)
NESTED TABLE "AUDITVALUE" STORE AS "AUDITVALUES"
(PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255…4 votesI’ve been working on this lately as although it could create a new table the migration scripts were very broken.
Let me know if you want a pre-release version to try the fix out.
This will included in the next release of the tools.
-
Objects included in the results - CommandLine
Filter for object types in command line application (SCO.exe).
There are several cases when to apply only changes for specific object types (i.e. package, procedure, function) instead of all differencies. Such as in GUI.
7 votesThis can now be done via a filter file in the latest command line release. Although I appreciate that a separate filter file isn’t ideal.
These filter files are generated by Source Control for Oracle as object filters although they are a simple xml format if you want to generate them yourself.
-
The tool ignored the DDL differences between a partitioned table and a regular one! how is it possible? it is basic !
differences between a partitioned table and a regular one! how is it possible? it is basic !
3 votesHi Oshrat,
By default Schema Compare has an option on to “ignore storage” as many customers are comparing environments that have different storage options. You can however turn this off in the options tab before comparing.
Do let us know if it’s that option that is in fact not working properly for you, but otherwise I’ll mark this as completed in a few days.
Cheers,
Michael -
Option to Ignore External Table Location
When comparing an External Table from one environment to the next, a difference in LOCATION (or filename) that the table refers to triggers a difference. We use External Tables to read data into our warehouse and currently have to manually ignore or remove those location changes from scripts when the difference is discovered. Adding an option to "Ignore External Table Location" would be very convenient for us.
14 votesThis is now in code (yet to be tested) for the next release of the tool.
This is now in our latest release via “Check for Updates”
-
Create or replace
For procedures/packages etc. it would be great to be able to have a "script as CREATE OR REPLACE" option.
We would use this to generate scripts that could be kept under source control in Mercurial, and applied to the (shared) dev database as needed.
We could also then use the tool to compare whether the database is up to date with the latest changes in source control.
39 votesI’ve just put this into our latest code so that we always generate CREATE OR REPLACE where we can. Surprisingly all the integration tests passed so this should make it into the next release.
I don’t think there are any huge issues with always using the CREATE OR REPLACE syntax.
This is now in our latest release via “Check for Updates”
-
Bug in compare with virtual column
When I do a schema compare that has added a virtual column the alter table command that it generates has a bug in it.
The statement it generates is:
ALTER TABLE vendorportaluser.vendorcontacts ADD (dbupperusername VARCHAR2(30 BYTE) GENERATED ALWAYS AS (UPPER("DBUSER_NAME")));Which results in error:
ORA-54015: Duplicate column expression was specifiedThe correct syntax is:
alter table VENDORPORTALUSER.VENDORCONTACTS add dbupperusername as (UPPER(DBUSER_NAME));1 vote -
Please add possibility to compare and copy table and column comments
We work a lot with table and columns comments, so they are mandatory. It would be nice to be able to compare the comments as well and be able to copy them.
3 votesthis has been included in Schema Compare 3.0.0.542 and Source Control 1.0.0.707
-
Rename column - instead of drop and create
If a column is renamed, Schema Compare for Oracle sees this as a drop and create, so during the table rebuild data is preserved asides from the “new” column.
Could you make this work similarly to SQL Compare and execute a rename instead?
8 votesI’ve done the work for column rename detection. This will be a default option in the next release of Schema Compare and Source Control for Oracle.
It probably won’t be perfect but the option can be turned off if it causes problems.
-
Allow limiting the deployment to only differences and objects missing , without project , at command line
I must prevent to drop any tables, because the database may contains other tables for another application.
And yes , they are in same schema.I need to deploy database changes on multiple databases, at client site, from a single snapshot.
5 votesIn the upcoming release drop table and drop column are both classed as high-level warning events which can easily be stopped. The command line tools as an option to not deploy if there are medium or high level warnings.
-
Allow partial compare of schemas based on naming convention
We manage ERP systems with larg schemas (150.000 - 200.000 objects) where only a small proportion - the custom objects - should be under source control / schema compared.
To enable a decent use of Schema Compare for these systems, we would need to be able to compare schemas partially based on naming convention. Multiple assignments per schema should be possible, e.g. we want to match all objects for schema ABC matching the naming convention EE% and FF%
40 votesIgnore Rules were implemented in v5.2 for Schema Compare, Data Compare, and Source Control for Oracle. More details can be found at https://documentation.red-gate.com/ddfo/other-resources/list-of-released-features. We hope this meets your needs and looking forward to hearing your feedback.
Thank you!
Stephanie Herr
Product Manager, Database DevOps -
dotNet version
System requirements for Schema Compare tell us about "Microsoft .NET Framework version 2.0 or later." Actually, the last version requires .NET version 4. The previous build required version 3.5 exactly. Such mess in versions frustrated me.
3 votesMany thanks for reporting this Sergey, we have now updated that page. We are using some features in .NET 4 for the latest version, apologies for the frustration, we won’t be updating again for a long time now.
-
Include materialized views in the schema compare
It seems materialized views are not included in the compare. Or am I missing something?
11 votesMaterialized Views and MVIEW Logs are now supported in v3.0.0.686. Available via Help→Check for Updates
-
Help Contents - 404 Error
I'm getting a "404: Page not found" when clicking on the "Help Contents" in version 3.0.0.219.
1 voteHi Curtis
Thanks for reporting this. As Neil mentioned previously, a redirect link on our website was broken.
I’m pleased to say it’s now been fixed, so when you click “Help→Contents” it will take you straight to the V3 help page.
Cheers,
— Brian
-
List Schema's Alphabetically
Please sort the list of schema's alphabetically. Things show up in kind of a strange order right now.
1 voteHi Bjorn – many thanks for your feedback. We had noticed this, and a similar issue with the ordering of TNS names, in our own testing recently. Both issues are fixed in Schema Compare for Oracle V3 which we’re expecting to release commercially in a couple of weeks. The major new functionality in this version is the ability to compare and deploy your schema to a scripts folder, which you can then put under source control. If you’d like to try V3 before then, you can download it by signing up to the Source Control for Oracle beta program on the Red Gate website.
-
Problem with schema compare 3
With large Oracle schemas it appears to hang at 44% with idle connections to the databases it is comparing.
1 voteHi Curtis
We think this should be fixed in the latest version of Schema Compare for Oracle which you can get by using the “Help→Check for updates” menu option in the tool.
If you could please try your comparison again with this new version, and let us know how it goes.
Cheers,
— Brian
-
Source Control Option - Generate object scripts in schema sub-folders
Source Control Option
When comparing multiple schemas all objects of same type go into one folder (e.g. all tables from all schemas into tables folder). In Oracle you normally look at objects by schema then type rather than this other way round.
Please provide option (and set as default) to export into schema sub-folders then object type folders
3 votesThis is now implemented in version 3.0.0.196 which you can get via the Help menu in the tool (Help→Check for Updates).
In this version multiple schemas are written to multiple sub-folders by default (the user just selects the parent folder) – we’ll look at adding a user-defined option to override this behaviour in a future release.
-
TNSNames list sorted?
On New Project list, can the TNSNames list (to connect to the db) be sorted alphabetically? Just makes it easier to browse.
1 voteUpdate: v3 of Schema Compare has been released which includes this feature.
Thank you for the suggestion! I’ve implemented this change for you on our early access branch and it will be included in the full product once the EA is complete. In the meantime you can get the EA from:
http://downloads.red-gate.com/EAP/SchemaCompareforOracleBeta/SchemaCompareforOracleBeta.exe
(this will install alongside any version you currently have installed if you want to give it a go)
- Don't see your idea?