The following suggestion is from a customer I performed a remote desktop session with.

Current in Schema Compare there is a single option to ‘Ignore constraint names’ when comparing objects. The constraints are still deployed. The option covers Primary Key, Foreign Key, Check, Default and Unique constraints.

Could this option be spilt up and replaced by the following 5 options:

• Ignore Foreign Constraints when comparing and deploying.
• Ignore Check Constraints when comparing and deploying.
• Ignore Default Constraints when comparing and deploying.
• Ignore Unique Constraints when comparing and deploying.
• Ignore Primary Key Constraints when comparing and deploying.

Are there any other Schema Compare for Oracle Users who would like to this occur?

Many Thanks
Eddie

Redgate Software Ltd
Technical Support Engineer