Perform Schema Comparison: Use DB Change Manager to identify and address potential issues in database schema. Schema compare capability helps you locate unanticipated problems immediately. Map the databases and schemas to pair the source and target databases for comparison. Use a live-to-live database compare to obtain a list of changed objects. First select which databases to compare, then proceed to refine the comparison parameters.
Set Comparison Filters: Refine your schema comparison using filters for owner, object, and type, to select the source items to compare against the target. This allows you to control the size and scope of the compare operation and its output. After that, specify object options and settings, choose manual or automatic synchronization, run the comparison, and review the list of results and reports generated.
View Alter Code: In the schema comparison detail report, see the SQL code required to implement the changes between schema archives, live data sources or both. DDL differences are color-coded for easy comparison. Promote schema changes from Development, to Test and finally to Production.
Protect Data Privacy: Shuffle or randomize columns in a data compare with an auto-synchronization job. De-identify data in the production environment and quickly migrate the masked, yet realistic and fully functional, data into Development, Test and QA environments.