PowerStudio DB結合了四種創新解決方案，可幫助您創建和維護關鍵數據庫應用程序並簡化變更管理流程。 數據，並快速識別和消除性能瓶頸。 DBArtisan執行多平台數據庫管理。
從單一界面管理多個平台（Oracle，SQL Server，DB2，Sybase）使用嵌入式分析主動管理空間。主要包括：
DBArtisan
從一個UI管理多個平台（Oracle，SQL Server，DB2，Sybase）
通過內置分析主動管理空間，數據和性能
使用智能診斷功能輕鬆查找和修復性能問題
輕鬆地在不同平台上移動架構和表格數據
通過查看，授予和撤消權限來保護數據安全
DB Change Manager
快速推出並協調數據庫更改
顯示，跟蹤和報告數據庫更改
遵守數據庫審計和報告要求
保護數據庫環境中的數據隱私
跟蹤多個主要數據庫平台的變化
DB Optimizer
從一個界面簡化主要DBMS上的SQL代碼調優
通過自動性能優化建議，像專業人士一樣調整SQL
使用可視化SQL調優圖解決複雜的SQL查詢
使用等待時間分析的數據庫分析來確定問題SQL
在模擬生產環境中加載測試備用SQL查詢
Rapid SQL
從一個接口在主要DBMS上創建高性能SQL代碼
使用可視化查詢構建器輕鬆構建複雜的SQL語句
使用代碼分析器快速構建，分析和執行SQL代碼
簡化調試SQL代碼，函數和存儲過程
通過版本控制在開發團隊之間有效協作
IDERA DB PowerStudio DBA Edition 17.0.4 |
The Idera product team is pleased to announce the availability of DB PowerStudio DBA Edition 17.0.4. This studio 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.
What's new in this release:
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.
DB PowerStudio is a highly-intuitive toolset that helps simplify cross-platform database administration, development, and performance tuning.
Designed for database teams that work in mixed DBMS environments, DB PowerStudio complements native tools with critical capabilities such as database change management and SQL optimization and tuning. DB PowerStudio comes complete with support for all popular DBMSes, including Oracle, SQL Server, Sybase ASE, DB2, and more. Whether it’s producing on-the-fly, DBMS-specific language conversions or creating new users across the entire enterprise, consistent workflows make it easy to extend one’s expertise into less familiar DBMSes.
Take your database administration and development capabilities to the next level with visual diagnostics that not only help you pinpoint problematic queries, but also determine best solutions. A unique Visual SQL Tuner saves hours or days of time when tuning problematic SQL. You’ll also enjoy deep change management functionality for cordinating database changes across the development life cycle, or for enforcing database configuration standards across your entire enterprise.
DB PowerStudio, DBA Edition provides DBArtisan for advanced database administration capabilities, as well as the ability to schedule and run multiple change management jobs at any time.
Simplify Database Administration and Change Management with DBArtisan and DB Change Manager
- Work with multiple DBMS brands and versions from a single toolset
- Easily carry out complex actions such as schema extraction, schema migration, and data load and unload
- Compare a live database to a schema or configuration “snapshot” to quickly identify changes and correct problems Maximize Database Performance and Availability with DBArtisan and DB Optimizer
- Use the optional DBArtisan Performance Analyst, Capacity Analyst and Space Analyst to see detailed metrics that identify performance, capacity planning, and storage management issues before they become problems
- Eliminate performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times), by relating resource utilization to specific queries, and by helping you visually tune problematic SQL
- Use powerful database monitors, intelligent diagnostic information and strong drill-down details to quickly find and fix performance issues
In this Skill Sprint we will look at working with datasources in both DBArtisan and Rapid SQL.
Idera, Inc. is the parent company of global B2B software productivity brands whose solutions enable technical users to do more with less, faster. Idera, Inc. brands span three divisions – Database Tools, Developer Tools, and Test Management Tools – with products that are evangelized by millions of community members and more than 50,000 customers worldwide, including some of the world’s largest healthcare, financial services, retail, and technology companies.
Product: IDERA DB PowerStudio
Version: DBA Edition 17.0.4 *
Supported Architectures: x64
Website Home Page : http://www.idera.com
Language: english
System Requirements: PC **
Supported Operating Systems: **
Size: 2.1 Gb
* DB PowerStudio is available in two editions: The DB PowerStudio DBA edition includes all four of the products listed below. The DB PowerStudio Developer edition includes Rapid SQL, DB Optimizer and DB Change Manager.
DBArtisan
Perform Multi-platform Database Administration
DB Change Manager
Automate and Manage Complex Database Schema Changes
DB Optimizer
Automate SQL Tuning and Profiling
Rapid SQL
Develop SQL Code More Efficiently
** System Requirements:
Minimum hardware requirements:
- 1 GHz or faster CPU
- 3 GB of RAM
- 1 GB of free disk space
- 1024 x 768 display
Supported Operating Systems:
- Windows 10, Windows 8.1, Windows 8, Windows 7 (32- and 64-bit)
- Windows Server 2008 SP1 & 2008 R2 (32- and 64-bit)
- Windows Server 2012 & 2012 R2
- Windows Server 2016
|
專業軟體光碟
