PowerStudio DB combines four innovative solutions that help you create and maintain critical database applications and streamline the change management process. data, and quickly identify and eliminate performance bottlenecks. Add. Information: DBArtisan Perform multi-platform database administration. Management of multiple platforms (Oracle, SQL Server, DB2, Sybase) from a single interface Proactively managing space, data and performance using embedded analytics
Easily find and fix performance problems using intelligent diagnostics. Easily move schema data and tables across platforms. Protect data security by viewing, granting, and revoking permissions. DB Change Manager Automate and manage complex database schema changes Quickly deploy and reconcile database changes Identify, track and report database changes Comply with audit and database requirements Protect data privacy in a database environment Track changes from several major DB database platforms Optimizer Automation of SQL tuning and profiling -Optimize SQL code tuning on major DBMSs from a single interface. -Set up SQL as a professional with suggestions for auto-optimizing performance. -Solve complex SQL queries using SQL tuning diagrams. -Identify SQL problem with time-out database profiling -Loading test alternative SQL queries in a simulated production Rapid environment SQL Develop SQL code -more efficiently Generate high-performance SQL code on major DBMSs from a single interface Easily -create complex statements SQL using visual query builder Quickly build, analyze and execute SQL code using code analytics
Simplify debugging of SQL code, functions, and stored procedures Effectively collaborate between development teams with DB version control PowerStudio DBA Edition includes all four of the products listed above.
DBArtisan Perform Multi-platform Database Administration -Manage multiple platforms (Oracle, SQL Server, Db2, Sybase) from one UI -Proactively manage space, data and performance with built-in analytics -Easily find and fix performance issues using intelligent diagnostics -Move schema and table data across different platforms with ease -Protect data security with view, grant and revoke of permissions
DB Change Manager Automate and Manage Complex Database Schema Changes -Quickly roll out and reconcile database changes -Reveal, track, and report on database changes -Comply with database audit and reporting requirements -Protect data privacy within the database environment -Track changes from multiple major database platforms
DB Optimizer Automate SQL Tuning and Profiling -Streamline tuning of SQL code on major DBMSs from one interface -Tune SQL like a pro with automated performance optimization suggestions -Tackle complex SQL queries with visual SQL tuning diagrams -Pinpoint problem SQL with database profiling of wait-time analysis -Load test alternative SQL queries in simulated production environment
Rapid SQL Develop SQL Code More Efficiently -Create high-performing SQL code on major DBMSs from one interface -Easily build complex SQL statements with visual query builder -Quickly construct, analyze and execute SQL code with code analyst -Simplify debugging SQL code, functions, and stored procedures -Collaborate effectively across development teams with version control
Application list: IDERA DB Change Manager 17.0.4 IDERA DBArtisan 17.0.4 IDERA DB Optimizer 17.0.4 IDERA RapidSQL 17.0.4
System requirements: OS: Windows 10,Windows 8.1,Windows 8,Windows 7 (64-bit) CPU:1 GHz or faster processor Memory:3 GB RAM Space:1 GB free disk space Monitor:Display 1024 x 768 Supported
WHATS NEW: Release Notes:
What's New in DB Change Manager 17.0.4 -added support for latest sql server and oracle versions -DB Change Manager 17.0.4 adds support for SQL Server 2019 and Oracle 19c
IDERA DBArtisan 17.0.4: -SQL Server 2019 (experimental support), PostgreSQL 11.2, Oracle 18c and 19c database support
Bug fixes: -DBArtisan hangs when updating statistics -Not able to grant execute privileges to roles or users on triggers -DDL extract shows wrong parameter -Java error when launching the debugger -DBArtisan crashes when working with 250,000 line file -Not able to invoke macros using hotkeys -The process monitor for 17.0.2 shows different results than older version of dbartisan -Group Object Privileges are incorrect -User can't copy information in SPID screen and paste into notepad -When reverse engineering DDL, Oracle licensing is violated -Add an option to remove the EDITIONABLE keyword from extracted objects -Can't see the parameters for an instance
IDERA RapidSQL 17.0.4: -SQL Server 2019 (experimental support), PostgreSQL 11.2, Oracle 18c and 19c database support
Bug Fixes: -Using Ctrl-E or -S erases query -Order to the trigger it is not showing
DERA DB Optimizer 17.0.4: -DB Optimizer 17.0.4 adds support for SQL Server 2019 and Oracle 19c.