IDERA DB PowerStudio DBA Edition 17.0.4  可幫助您創建和維護關鍵數據庫應用程序並簡化變更管理流程
PowerStudioDB結合了四種創新解決方案，可幫助您創建和維護關鍵數據庫應用程序並簡化變更管理流程。數據，並快速識別和消除性能瓶頸。DBArtisan執行多平台數據庫管理。
從單一界面管理多個平台（Oracle，SQLServer，DB2，Sybase）使用嵌入式分析主動管理空間。主要包括：
DBArtisan

從一個UI管理多個平台（Oracle，SQLServer，DB2，Sybase）
通過內置分析主動管理空間，數據和性能
使用智能診斷功能輕鬆查找和修復性能問題
輕鬆地在不同平台上移動架構和表格數據
通過查看，授予和撤消權限來保護數據安全
DBChangeManager

快速推出並協調數據庫更改
顯示，跟蹤和報告數據庫更改
遵守數據庫審計和報告要求
保護數據庫環境中的數據隱私
跟蹤多個主要數據庫平台的變化
DBOptimizer

從一個界面簡化主要DBMS上的SQL代碼調優
通過自動性能優化建議，像專業人士一樣調整SQL
使用可視化SQL調優圖解決複雜的SQL查詢
使用等待時間分析的數據庫分析來確定問題SQL
在模擬生產環境中加載測試備用SQL查詢
RapidSQL

從一個接口在主要DBMS上創建高性能SQL代碼
使用可視化查詢構建器輕鬆構建複雜的SQL語句
使用代碼分析器快速構建，分析和執行SQL代碼
簡化調試SQL代碼，函數和存儲過程
通過版本控制在開發團隊之間有效協作

IDERADBPowerStudioDBAEdition17.0.4| 
TheIderaproductteamispleasedtoannouncetheavailabilityofDBPowerStudioDBAEdition17.0.4.Thisstudiocombinesfourinnovativesolutionsthathelpyoucreateandmaintaincriticaldatabaseapplicationsandstreamlinethechangemanagementprocess.data,andquicklyidentifyandeliminateperformancebottlenecks.

What'snewinthisrelease:

What'sNewinDBChangeManager17.0.4
-addedsupportforlatestsqlserverandoracleversions
-DBChangeManager17.0.4addssupportforSQLServer2019andOracle19c
IDERADBArtisan17.0.4:
-SQLServer2019(experimentalsupport),PostgreSQL11.2,Oracle18cand19cdatabasesupport
Bugfixes:
-DBArtisanhangswhenupdatingstatistics
-Notabletograntexecuteprivilegestorolesorusersontriggers
-DDLextractshowswrongparameter
-Javaerrorwhenlaunchingthedebugger
-DBArtisancrasheswhenworkingwith250,000linefile
-Notabletoinvokemacrosusinghotkeys
-Theprocessmonitorfor17.0.2showsdifferentresultsthanolderversionofdbartisan
-GroupObjectPrivilegesareincorrect
-Usercan'tcopyinformationinSPIDscreenandpasteintonotepad
-WhenreverseengineeringDDL,Oraclelicensingisviolated
-AddanoptiontoremovetheEDITIONABLEkeywordfromextractedobjects
-Can'tseetheparametersforaninstance
IDERARapidSQL17.0.4:
-SQLServer2019(experimentalsupport),PostgreSQL11.2,Oracle18cand19cdatabasesupport
BugFixes:
-UsingCtrl-Eor-Serasesquery
-Ordertothetriggeritisnotshowing
DERADBOptimizer17.0.4:
-DBOptimizer17.0.4addssupportforSQLServer2019andOracle19c.

DBPowerStudioisahighly-intuitivetoolsetthathelpssimplifycross-platformdatabaseadministration,development,andperformancetuning.

DesignedfordatabaseteamsthatworkinmixedDBMSenvironments,DBPowerStudiocomplementsnativetoolswithcriticalcapabilitiessuchasdatabasechangemanagementandSQLoptimizationandtuning.DBPowerStudiocomescompletewithsupportforallpopularDBMSes,includingOracle,SQLServer,SybaseASE,DB2,andmore.Whetherit’sproducingon-the-fly,DBMS-specificlanguageconversionsorcreatingnewusersacrosstheentireenterprise,consistentworkflowsmakeiteasytoextendone’sexpertiseintolessfamiliarDBMSes.

Takeyourdatabaseadministrationanddevelopmentcapabilitiestothenextlevelwithvisualdiagnosticsthatnotonlyhelpyoupinpointproblematicqueries,butalsodeterminebestsolutions.AuniqueVisualSQLTunersaveshoursordaysoftimewhentuningproblematicSQL.You’llalsoenjoydeepchangemanagementfunctionalityforcordinatingdatabasechangesacrossthedevelopmentlifecycle,orforenforcingdatabaseconfigurationstandardsacrossyourentireenterprise.
  
DBPowerStudio,DBAEditionprovidesDBArtisanforadvanceddatabaseadministrationcapabilities,aswellastheabilitytoscheduleandrunmultiplechangemanagementjobsatanytime.

SimplifyDatabaseAdministrationandChangeManagementwithDBArtisanandDBChangeManager
-WorkwithmultipleDBMSbrandsandversionsfromasingletoolset
-Easilycarryoutcomplexactionssuchasschemaextraction,schemamigration,anddataloadandunload
-Comparealivedatabasetoaschemaorconfiguration“snapshot”toquicklyidentifychangesandcorrectproblemsMaximizeDatabasePerformanceandAvailabilitywithDBArtisanandDBOptimizer
-UsetheoptionalDBArtisanPerformanceAnalyst,CapacityAnalystandSpaceAnalysttoseedetailedmetricsthatidentifyperformance,capacityplanning,andstoragemanagementissuesbeforetheybecomeproblems
-Eliminateperformancebottlenecksbyvisuallyprofilingkeymetricsinsidethedatabase(CPU,I/O,waittimes),byrelatingresourceutilizationtospecificqueries,andbyhelpingyouvisuallytuneproblematicSQL
-Usepowerfuldatabasemonitors,intelligentdiagnosticinformationandstrongdrill-downdetailstoquicklyfindandfixperformanceissues

InthisSkillSprintwewilllookatworkingwithdatasourcesinbothDBArtisanandRapidSQL.

Idera,Inc.istheparentcompanyofglobalB2Bsoftwareproductivitybrandswhosesolutionsenabletechnicaluserstodomorewithless,faster.Idera,Inc.brandsspanthreedivisions–DatabaseTools,DeveloperTools,andTestManagementTools–withproductsthatareevangelizedbymillionsofcommunitymembersandmorethan50,000customersworldwide,includingsomeoftheworld’slargesthealthcare,financialservices,retail,andtechnologycompanies.

Product:IDERADBPowerStudio
Version:DBAEdition17.0.4*
SupportedArchitectures:x64
WebsiteHomePage:http://www.idera.com
Language:english
SystemRequirements:PC**
SupportedOperatingSystems:**
Size:2.1Gb

*DBPowerStudioisavailableintwoeditions:TheDBPowerStudioDBAeditionincludesallfouroftheproductslistedbelow.TheDBPowerStudioDevelopereditionincludesRapidSQL,DBOptimizerandDBChangeManager.

DBArtisan
PerformMulti-platformDatabaseAdministration
DBChangeManager
AutomateandManageComplexDatabaseSchemaChanges
DBOptimizer
AutomateSQLTuningandProfiling
RapidSQL
DevelopSQLCodeMoreEfficiently

**SystemRequirements:
Minimumhardwarerequirements:
-1GHzorfasterCPU
-3GBofRAM
-1GBoffreediskspace
-1024x768display
SupportedOperatingSystems:
-Windows10,Windows8.1,Windows8,Windows7(32-and64-bit)
-WindowsServer2008SP1&2008R2(32-and64-bit)
-WindowsServer2012&2012R2
-WindowsServer2016