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%12 votes
It seems materialized views are not included in the compare. Or am I missing something?11 votes
Materialized Views are currently being added to v3 of Schema Compare.
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?6 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.
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
when migrating indexes in schema compare,bitmap indexes on a partitioned table fail - local clause missing1 vote
- Don't see your idea?