59 results found
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 votes
this has been included in Schema Compare 184.108.40.2062 and Source Control 220.127.116.117
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 votes
In 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.
Generate a script that contains all the synonyms that have been created to support the schema being version controlled.9 votes
I believe this is a request for public synonyms which has been implemented in the latest release.
Please let me know if that’s incorrect.
Add support to ORACLELOADER and ORACLEDATAPUMP access drivers to fix some bugs related to external tables (see http://www.red-gate.com/MessageBoard/viewtopic.php?t=16543)1 vote
external tables were included in v18.104.22.1687
Allow for saving of database versioning in a sub-folder of the subversion repository rather than just the root of the repository.4 votes
This should now be fixed in the beta released yesterday (21 Feb), please do let us know if there are still issues!
When a repository is created from the database, both the package header and the package body are placed in a single file. It would be more usable if the spec and body were in separate files in the same folder with a .pks or .pkb extension respectively.9 votes
this will be in the next release of Schema Compare and Source Control for Oracle
We noticed that all objects have a prefix in front of it.
The prefix happens to be the same as your folder name. I would prefer it if it was the same as the schema name, or NULL. Preferably give us the right to choose a prefix name.9 votes
I believe you can do this in the latest version of Source Control.
Either you can make your schema name the same as the folder when you setup your project.
Or you can now access the options via right-click on the project on the projects page and select “Edit comparison options…” and use the option “Exclude schema names”
Could you please make it possible to compare tables with different tablenames?
This should be applied to all tools.
I do believe this is possible in the SQL Server-tools.50 votes
It is possible to map differently named tables and views in Data Compare for Oracle v4. Apologies for the wait. Let us know if this doesn’t meet your expectations. https://documentation.red-gate.com/dco4/setting-up-the-comparison/selecting-tables-to-compare
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 votes
Ignore 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.
Product Manager, Database DevOps
The SID for my oracle instance is 10 characters. The connection wizard only allows 8 characters so can't use the product.3 votes
shipped via check for updates today
When checking in a new package from the database, the schema name in references throughout the package is changed to have double quotes around it. Then when a change is made on the file, the entries from the database without the double quotes do not match the entries from source control with the double quotes. It seems that this difference alone isn't enough to show the comparison as different, but when another difference exists, these entries are all flagged as different. To resolve this, the double quotes should not be created in the first place.1 vote
Thanks Leigh. We believe this is fixed in the latest beta release, please do advise.
It seems materialized views are not included in the compare. Or am I missing something?11 votes
Materialized Views and MVIEW Logs are now supported in v22.214.171.1246. Available via Help→Check for Updates
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 votes
Many 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.
I'm getting a "404: Page not found" when clicking on the "Help Contents" in version 126.96.36.199.1 vote
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.
Please sort the list of schema's alphabetically. Things show up in kind of a strange order right now.1 vote
Hi 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.
With large Oracle schemas it appears to hang at 44% with idle connections to the databases it is comparing.1 vote
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.
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 folders3 votes
This is now implemented in version 188.8.131.52 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.
On New Project list, can the TNSNames list (to connect to the db) be sorted alphabetically? Just makes it easier to browse.1 vote
Update: 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:
(this will install alongside any version you currently have installed if you want to give it a go)
Data Compare for Oracle: Option: Comparisaon behavior - Trim Trailing Spaces: Is it possible to uncheck by default this option?
When I used this tool, I want that, by default, he copies over all data exactly the same as they exist in the source; so including trailing spaces.
In my opinion you set/change an option if you want that your data should be 'transformed' during the transfer form source to target. At that moment, it is a conscious choice.1 vote
I’m going to close this as David mentions you should be able to save your default comparison options. Do let us know if that isn’t the case.
- Don't see your idea?