it:dbtools
Embarcadero
in general each of these tools can be purchased for a single database platform (eg. MS SQL Server) or for all supported platforms
these use JDBC database drivers and are based on Java technology
NB. in SQL Server platform, SQL Server Express is NOT supported, only Microsoft SQL Server 2005, 2008, 2012
DB Power Studio
usual version
"DEV" version
DB Optimizer
DEV edition
database profiling
profile chart shows the CPU, I/O, and other wait activity over the course of the session. Zoom in/out functionality available. (Wait categories vary by platform.)
Detailed information on the profiled SQL and wait categories, broken down by SQL statements, events, and sessions.
load testing
sampling to identify and diagnose performance bottlenecks and problematic SQL without agents or placing a significant load on the target database
SQL stress testing simulates a number of parallel users and executions over a specific period of time or execution cycle.
Continuously profile an entire data source within a configurable span of time
reporting
Pro version
Rapid SQL
standard edition ?"DEV" edition
PRO version
DB Change manager
DEV version
PRO version
DEV version plus:
Auditing
Use custom or live configurations to create standards. Audit database configurations to check for security liabilities and performance standards
Identify and report on changes to the database at or between points in time, or to particular sensitive objects: ad hoc or on a regular basis. Audit database configurations against established standards to minimize the vulnerability of your databases.
Data Masking
Ensure accurate testing while complying with international privacy laws
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.
ENT version
DB Artisan
it/dbtools.txt · Last modified: 2014/07/15 12:04 by gary1