dbForge Studio 2019 for MySQL v8.2.23 Enterprise Edition 一個非常好用而又專業的mysql界面工具 
dbForgeStudioforMySQL是用於MySQL和MariaDB數據庫開發、管理和管理的通用GUI工具。IDE允許您創建和執行查詢、開發和調試存儲例程、自動化數據庫對象管理、通過直觀的界面分析表數據。MySQL客戶機提供數據和模式比較和同步工具、數據庫報告工具、帶有調度的備份選項等等。

此外，dbForgeStudioforMySQL是MySQL工作臺的完美替代品。看看我們的工具在MySQL工作臺上的優點吧！

數據庫開發

通過以下功能，構建、編輯和運行查詢以及測量和優化查詢性能變得簡單得多：

數據庫設計

數據庫設計工具允許用戶創建數據庫關系圖、對象、項目，以及在用戶友好的界面中高效地比較和同步數據庫架構。

數據庫管理

使用這些功能，用戶可以管理其帳戶、設置權限、監視打開的會話及其活動，以及執行表維護。此外，還可以在備份文件中備份和還原數據庫。

數據報告和分析

創建數據報表和數據透視表以及數據比較和同步可能需要花費大量時間和精力，而使用以下功能可以提高工作效率

Description:
dbForgeStudioforMySQLisauniversalGUItoolforMySQLandMariaDBdatabasedevelopment,management,andadministration.TheIDEallowsyoutocreateandexecutequeries,developanddebugstoredroutines,automatedatabaseobjectmanagement,analyzetabledataviaanintuitiveinterface.TheMySQLclientdeliversdataandschemacomparisonandsynchronizationtools,databasereportingtools,backupoptionswithscheduling,andmuchmore.

Inaddition,dbForgeStudioforMySQLisaperfectalternativetoMySQLWorkbench.CheckouttheprosofourtooloverMySQLWorkbench!

DatabaseDevelopment
Building,editing,andrunningqueries,aswellasmeasuringandoptimizingqueryperformancegetmuchsimplerwiththefollowingfunctionality:

DatabaseDesign
Databasedesigntoolsallowuserstocreateadatabasediagram,objects,projects,aswellastocompareandsynchronizedatabaseschemasefficientlyandinauser-friendlyinterface.

DatabaseAdministration
Withthesefeatures,userscanmanagetheiraccounts,setuppermissions,monitoropensessionsandtheiractivity,aswellasperformtablemaintenance.Inaddition,itispossibletobackupandrestoredatabasesto/fromabackupfile.

DataReportsandAnalysis
Creationofdatareportsandpivottables,aswellasdatacomparisonandsynchronizationmaytakemuchtimeandeffortswhileyourworkcanbemoreproductiveusingthefollowingfeatures:

Features

dbForgeStudioforMySQLiscompatiblewith:
-AllMySQLserverversions
-AllMariaDBserverversions
-PerconaPAMAuthenticationforMySQL
-SphinxSearchEngine

IntelligentSQLCoding
-Intelligentcodecompletion,formatting,MySQLprompt,andcodesnippetsbringconvenienceandeffectivenesstoyourSQLcodewriting.Codenavigation,obtainingquickobjectinformation,andsyntaxcheckareperformedinstantly.

DatabaseCompareandSync
-WhenmodifyingMySQLdatabasestructure,transferringdatabetweenservers,analyzingdifferencesbetweendatabases,youwill:
-Compareandsyncdataandschemas
-Scheduleregulardatabasesynctasks
-Generatecomparisonreport

DataGenerator
-PopulateyourMySQLtableswiththousandsofrowsofrealistictestdata.DataGeneratorsupportsallMySQLdatatypes,includesalargenumberofmeaningfulgeneratorswithcustomizablesettings,andallowsgeneratingdataviathecommand-lineinterface.

DocumenterAtoolforgenerationofMySQLandMariaDBdatabasedocumentation.Documenterallowsyouto:
-Retrieveanoverviewofthedatabasestructure
-Viewinter-objectandinter-databasedependencies
-Customizedocumentationwithstyletemplates
-GeneratedocumentationfilesintheHTML,PDFandMarkdownformats

VisualQueryBuilder
-Visualquerycreationwithdiagramandexpressioneditor.Queriesofanycomplexitycanbecreatedinseveralseconds.TheGUItoolautomaticallyaddsjoinsbetweentablesandallowsworkingwithINSERT,UPDATE,DELETEstatements.

dbForgeStudioforMySQL-VisualQueryBuilderDatabaseDesigner

-Usedatabasediagramforcreating,analyzing,reverse-engineering,printingandcustomizingyourMySQLdatabasesandfor:
-Viewingforeignkeyrelations
-DisplayingDBobjectswithproperties
-Executionofstoredroutines

dbForgeStudioforMySQL-DatabaseDesignerImport/ExportData
-FillMySQLdatabaseswithexternaldatausingourexportandimporttools.Theysupportmorethan10populardataformatsandallowcustomizingthewholeprocess.Templates,automatingdataimportanddataexporttasksthroughcommandlinearealsoavailable.

dbForgeStudioforMySQL-Import/ExportDataDatabaseBackup
-DumpdatabasesinSQLformatandscheduleregularMySQLdatabasebackups.Use5levelsoffilecompressionandwidesetofoptionstofine-tunebackups.Saveyoursettingsandconnectionsasaprojectforthenexttimeortouseinthecommandline.

dbForgeStudioforMySQL-DatabaseBackupDatabaseAdministration

ToolsforMySQLdatabaseadministrationandmanagementincludemeansfor:
-Managinguserprivileges
-MySQLservicecontrol
-Managingservervariables
-Tablemaintenance
-Managingserversessions

dbForgeStudioforMySQL-DatabaseAdministrationMySQLDebugger
-ThefirstdebuggerforMySQLthatoffersstep-by-stepcodeexecution,breakpoints,watches,acallstack,avariablesevaluationmechanismtoautomatedebuggingofMySQLstoredroutinesandtriggersandkeepsMySQLserver'slogicofprocedureexecution.

TableDesigner
-Visualdesignerformodifyingorcreatingtablestructure,indexes,primarykeys,defaults,andCHECKconstraints.Getfullcontroloverthechangesyouhavemade.Theheuristicsfeaturewillsuggestacolumntypeoncreatingacolumnbasedonthenameyouenter.

DatabaseRefactoring
-ImproveMySQLdatabasedesignbyapplyingsmallchanges.Whensuchchangesareperformed,theyarefullytransparentandapplicationtakescareofalldependenciesinthedatabase:
-Renamingdatabaseobjectswithpreview
-Refactoringscript

Improvemulti-secondqueriesusingQueryProfiler.ThetoolhelpsyoudetectproblemsandoptimizeSQLqueriesviaGUI.Profiler:
-Offersvisualqueryprofiling
-Comparesprofilingresults

ReportandAnalysis
-Datareportingisperformedusingwizardwithrichfeatureset,manually,orviacommandline.Readyreportscanbeimportedto9formatsanddeliveredtotheirrecipients.
-Groupandsummarizeyourdatainpivottablestomakeiteasiertoreadandunderstand.

DatabaseProjects
-TheDatabaseProjectisacollectionofSQLscriptsandqueryfileswhichallowsyoutologicallyorganizetheminoneplaceandinanofflinemode.Withthistechnologyyoucancompareadatabaseprojectwithadatabase,byreceivingasynchronizedscript,anddeploydatabasechanges.

CopyDatabase
TransferMySQLServerdatabasesfromoneserverinstancetoanotherwithahandyCopyDatabasestool.Thetoolallowsyouto:
-Customizecopyingsettings
-Copydatabasestogetherwithdata
-Dropadatabaseifitalreadyexistsonatargetserver

MySQLandMariaDBConnectivity:
-SupportforallMySQLserverversions3.23-8.0
-SupportforallMariaDBserverversions5.5-10.4
-SecureconnectionsviaSSL/SSH
-HTTPconnectionsviaPHPtunnel
-SupportforUTF-8databases
-WorkwithMySQLembeddedserver
-DirectaccesstoMySQLserverwithoutclientlibraries
-MySQLpluggableauthenticationandWindowsauthenticationonconnectingtoMySQLserver(PAM)
-SupportforWindowsauthenticationwhencreatingconnectiontoMySQLserver
-WorkingwithMySQLonAmazonRDSandonAmazonAurora
-PerconaPAMAuthenticationforMySQL
-SphinxSearchEngine
-GaleraCluster
-GoogleCloudPlatform
-AlibabaCloud
-AzureMySQL

SystemRequirements:
OS:MicrosoftWindowsXP,7,8,8.1,10,WindowsServer2008,2012
CPU:2GHzorhigherprocessor
Memory:1024MBRAM
Space:150MBoffreeharddiskspace
dbForgeStudio2019forMySQLv8.2.23EnterpriseEdition
WhatsNew:
-ProblemwithconnectiontoAzureDatabaseforMySQLisfixed(T289434).

Homepage
https://www.devart.com/