• Ensure availability and integrity by enabling quick recall of previous database versions.
• View detailed analysis of what has been changed to identify the fault and focus your corrective actions accordingly.

  Inconsistencies

 Challenges

• How to ensure that changes made to the database don’t have an adverse affect when moving to production.
• How to quickly identify what, where and how objects have changed.
• How to ensure that logical schema changes are complete.

 Solution

• Use dbMaestro to compare database version changes and analyze the impact of specific changes on dependent objects.
• View dbMaestro's version reports to identify the extent and consistency of changes made to the schema.

 Benefits

• Save time and effort involved in planning and executing changes to your database.
• Automate the validation of changes across your schema.
• Quickly analyze the impact of planned changes to your working database.
• Ensure that changes are implemented uniformly throughout your entire database.

 

  Maintenance

 Challenges

• How to easily weed out obsolete objects in order to optimize the database.
• How to quickly recognize which objects are obsolete and which are importan.
• How to quickly revert back to older objects should they require reinstatement.

 Solution

• Use dbMaestro to view object dependencies and histories.
• Use dbMaestro’s transaction analysis to gauge an object’s usage patterns.
• Easily revert back to previous object versions should you need to.

 Benefits

• Enable ongoing maintenance and optimization of your database by “weeding out” old, obsolete objects.
• Save time in deployment, debugging, backup and routine maintenance by keeping your database optimized.
• Lower the risk involved in “weeding out” obsolete objects by being able to quickly “undo” changes.

 

  Deployment - Consistent Versions

 Challenges

• How do you validate deployments.
• How do you effectively compare database deployments for differences.
• How do you quickly diagnose differences in behavior and performance from different server installations.

 Solution

• Use dbMaestro to compare currently deployed database versions with the master version package.
• Compare multiple servers with each other to identify differences.

 Benefits

• Save time and effort involved in planning and executing changes to your database.
• Automate the validation of changes across your schema.
• Quickly analyze the impact of planned changes to your working database.
  Ensure that changes are implemented uniformly. 

 

  Deployment – Planning

 Challenges

• How to pre-validate database version changes and pre-requisites prior to deployment.
• How to quickly package incremental changes to schema and data as an installation ready package.
• How to lower the risk involved in complex deployment scenarios.

 Solution

• Use dbMaestro to create database version migration packages.
• Pre-validate versions against deployed servers.

 Benefits

• Save time and effort involved in planning and executing database version deployments.
• Automate the deployment sequence across multiple servers.
  Generate and keep detailed reports on deployments. 

 

  Deployment - Consistent Database Versions

 Challenges

• How do you validate deployments.
• How do you effectively compare different database deployments for differences.
• How do you quickly diagnose differences in behavior and performance from different server installations.

 Solution

• Use dbMaestro to compare currently deployed versions with the master version package.
• Compare databases on multiple servers to identify differences.

 Benefits

• Save time and effort involved in planning and executing changes to your database.
• Automate the validation of changes across your schema.
• Quickly analyze the impact of planned changes to your working database.
• Ensure that changes are implemented  uniformly.

 

  Deployment - Automating Validation

 Challenges

• How to ensure that new versions roll out quickly and securely.
  How to simplify the validation of deployments on multiple servers.
  How to audit what was deployed to where.

 Solution

• Use dbMaestro to manage deployments to multiple servers.
• Use dbMaestro's “Server Compare” features to compare and
• validate servers against your target deployment package.

 Benefits

• Save time and dramatically reduce the risk involved in multi-server deployment.
• Maintain detailed deployment history across servers.
• Save time by automating the validation procedure in multi-server deployments.

 

  Deployment - Undo Changes

 Challenges

• How to quickly undo recent changes and revert back to previous version settings.
• How to maintain a history of changed schema, configuration parameters and data to enable a simple “Undo” .

 Solution

• Use dbMaestro to manage deployment histories with granular aggregation of changes to objects.
• Use dbMaestro's “Undo” features to quickly “undo” a recent change either by reverting to a previous database version or granularly controlling which change should be rolled back.

 Benefits

• Ensure availability and integrity by enabling quick undo of recent erroneous changes.
• Provide immediate support for stabilizing a new version without requiring assistance from the development team.
• View a detailed analysis of what has changed to identify the fault and focus your corrective actions accordingly.