Page History

IDERA DB Optimizer simplifies SQL optimization and development for application developers with many features for improving productivity and reducing errors. A rich SQL IDE with statement tuning, data source profiling, code completion, real-time error checking, code formatting and sophisticated object validation tools helps streamline coding tasks. DB Optimizer’s user interface helps improve overall productivity with integrated development, monitoring, and tuning components.

DB Optimizer has four components that when used together can optimize your database performance. 

Change Manager helps database administrators and developers to:

• Simplify and automate database change management.
• Streamline development cycles.
• Ensure availability, performance, and compliance.

DB Change Manager provides comparison, synchronization, data masking, and auditing capabilities that let you track and report on changes, roll out new releases, and pinpoint problems resulting from changes at the data, schema, and database configuration levels. 

By comparing a live database to a schema or configuration “snapshot,” administrators can quickly identify changes and correct problems. By monitoring configuration settings, administrators can ensure compliance with regulatory policies and performance standards and maintain overall database performance and availability.

What can you do with DB Change Manager?

This topic describes what you can do with DB Change Manager and links to more detailed information about how to perform the tasks. In addition, DB Change Manager includes step-by- step Eclipse-style cheat sheets to help you learn the tasks.

• Complete Commonly-performed tasks. These tasks describe basic functions and help you use DB Change Manager most effectively. In addition, you can customize the interface using preferences. See the Preferences reference for details.
  • Registering and organizing data sources
  • Creating a job report
  • Scheduling a job
  • Filtering data source objects
  • Searching for database objects and synchronization scripts
  • Viewing Change History
  • Exporting and importing jobs
• Compare and synchronize data. Data Comparison jobs help you manage data changes and synchronize changes between databases.
  • Comparing data
  • Synchronizing data repositories
• Compare and synchronize schemas. In DB Change Manager you can select schema objects and types, compare them across data sources, and synchronize them to each other. You can also create a snapshot or archive of the schema objects, to use in a comparison or to save for future reference. In addition, you can clone schema comparison jobs to make it easier to reuse existing jobs.
  • Comparing schemas, including how to clone a schema comparison job
  • Synchronizing schemas
  • Creating a schema archive
• Manage database configurations. DB Change Manager helps you keep track of database settings and version information; such as patch levels. You can define database configuration values and ranges and then run a configuration comparison job to check for compliance against those parameters.
  • Comparing database configuration settings
  • Creating a standard for configuration settings
  • Creating a configuration archive
• Create masked data for development environments. Protecting personally identifiable information while having accurate data for testing can be difficult. DB Change Manager lets you create a masked copy of production data for use during development and testing. This way the data is functionally correct and at the same time does not compromise privacy or security.
  • Masking data
• Automate and script jobs. You may need some jobs to run on a regular basis without using Windows Task Scheduler (as described in Scheduling a job.) The Script Wizard lets you define scripts that run jobs, and batch files to run multiple scripts.
  • Scheduling a job
  • Generating command line scripts
• SQL Editor. A developer can write Java in Eclipse that calls to the database with SQL. The SQL that calls to the database can be written in the SQL Editor with type ahead, code assist and quick fixes to show the users syntax and correct mistakes. For more information, see Creating and editing SQL files (SQL Editor).
• Load Tester. The SQL code can be run in the Load Tester to test execution by multiple concurrent users. User load testing is so often done by one single user and then problems don’t appear until production with multiple concurrent users. Concurrent user testing is a breeze in DB Optimizer. For more information, see Using SQL Load Editor/Tester.
• Profiler. You can run the Profiler while the Load Tester is executing to show clearly the impact on the database. The profiler can also be used by QA on load simulation. Finally, the Profiler can be run on any production database to clearly show load, bottlenecks, and sources of bottlenecks or resource consumption. For more information, see Using profiling.
• Tuner. Finally, if a problem SQL is found on the system the Tuner will show if it’s correctly optimized by the database or not, and if not it will show the best plan and what hints or optimizer directives can be included in the SQL to force the database to use the optimal plan. For more information, see Using tuning.