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.28 votes
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%16 votes
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.11 votes
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?7 votes
as SQL Schema compare sdk5 votes
Similar to the SQL Server Product, Source Control should be an option as a Source or Target for the comparison.4 votes
I'd like the ability to compare schema, role and other database level objects for deployment. Most notably schemas (users) and roles.4 votes
Specifically, please allow exclusion of packages, as our DBAs have restricted access to the all_source table.
(If you vote on this idea please mention any specific or general rules you'd like to pre-filter by)3 votes
When your source or destination is an SVN repository allow to select a specific revision of the repository.
It is true that there are workarounds for this but it would save time to do it automatically in the tool because now either you have to checkout or update to an specific revision from the svn or you have to create tags in your repository for each version.3 votes
The function of Schema Compare that compares schemas with script folders has the problems that it ignores all extentions different than sql.
It would be useful to support files with different extensions, either by allowing to configure ignored extensions (all other will be treated as sql) or by allowing to configure extensions for specific types of objects.2 votes
Thanks for your request – it’s under review with the DEV team,.
I have a schema where synonyms are not being compared correctly. In particular this is a synonym that refers to a remote object. Is this a known limitation of Schema Compare?2 votes
Hi – thanks for the feedback. There is some basic support for synonyms in Schema Compare, but without more detail it’s hard to say how the tool should behave in this scenario.
If you could provide some more details of the issue, and describe what you were expecting to see in the comparison results, that would be really useful.
If you’d prefer not to post the data in this forum, please email it to email@example.com and we’ll get back to you.
Create snapshot options should be similar to those in the SQL Server tool. We are currently limited to snapshot only from TNS and manual connection. We should have the options to create a snapshot from script file or source control. This is vital to our build automation2 votes
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.2 votes
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 vendor_portal_user.vendor_contacts ADD (dbupper_username VARCHAR2(30 BYTE) GENERATED ALWAYS AS (UPPER("DBUSER_NAME")));
Which results in error:
ORA-54015: Duplicate column expression was specified
The correct syntax is:
alter table VENDOR_PORTAL_USER.VENDOR_CONTACTS add dbupper_username as (UPPER(DBUSER_NAME));1 vote
We believe this to be fixed in the latest Schema Compare release, now available via Help → Check for Updates within the tool.
If you (or anybody else reading) are still having issues with virtual columns please do comment below or send us an email to firstname.lastname@example.org.
when migrating indexes in schema compare,bitmap indexes on a partitioned table fail - local clause missing1 vote
- Don't see your idea?