Schema Manager eases the deployment of schema changes from development to test to production by managing dependencies while maintaining control with extensive change documentation. Schema Manager enables developers and DBAs to effortlessly control hundreds of different schemas across any number of databases. Schema Manager with a powerful array of features for applying, tracking, versioning and auditing, you can deploy and rollback changes with confidence.

Schema Manager make complex schema changes quickly and accurately
Generate "apply" and "rollback" scripts automatically
Compare, version and synchronize the script schemas and PL/SQL
Integrated with Data Manager for intelligent data extracts, data migrations and deployments throughout the software lifecycle
Eliminate guesswork when applying patches to Oracle Applications by quickly comparing multiple schemas and database objects
Analyze the impact code changes will have on your databases or the impact database changes will have on your source code
Instantly set up storage and privileges
Automatically document all changes
Integrated data management
Built-in scheduler to manage script execution
Making Complex Tasks Simple
As a comprehensive Oracle database deployment solution for facilitating schema changes, Schema Manager meets all change requirements regardless of the change process involved.

Typically, developers and DBAs make schema changes directly to the development database. Due to the complexity, making or synchronizing a schema change can be a daunting task. A single complex change - such as renaming a column - can take hours to implement manually. Deploying hundreds of changes - from development to test to production - on schedule and without error is an even greater challenge. To be successful, these changes must be packaged into a coordinated release and applied in the correct order, or manipulated for storage, privileges and other environmental changes. Schema Manager's GUI-driven, fully-automated schema change process dramatically reduces the potential for errors and data loss while increasing productivity.

Data Manager Integration
The integration of Data Manager and Schema Manager results in a powerful solution for intelligently applying and rolling back both schema and data changes. You can easily and accurately move data between Oracle databases throughout the application lifecycle. For example, one common request is to extract a logical subset of production data for use in testing. Manually building the SQL scripts to extract this data can take weeks; building the test schema as a complete, partial or scaled-down copy of the production schema is another complex task. Data Manager facilitates these tasks and meets many other data management challenges such as the following: deploy reference data from development to production; extract data to a data warehouse or reporting database, purge and archive production data; move data between heterogeneous databases (e.g., from Oracle to SQL Server).