dbForge Studio 2019 for SQL Server v5.8.107 Enterprise Edition  用於SQL服務器管理、管理、開發、數據報告和分析
dbForgeStudioforSQLServer是一個強大的IDE，用於SQL服務器管理、管理、開發、數據報告和分析。它幫助SQL開發人員管理數據庫，在流行的源代碼管理系統中版本控制數據庫的更改，加快日常任務的執行速度，以及進行復雜的數據庫更改。

一個方便的工具，用於分析SQL索引的狀態，並解決索引碎片化的問題。索引管理器允許您快速收集索引碎片統計信息並檢測需要維護的數據庫。您可以在可視化模式下立即重建和重新組織SQL索引，或者生成SQL腳本以供將來使用。

為數據庫開發註入活力。

dbForgeStudioforSQLServer是一個強大的IDE，用於SQL服務器管理、管理、開發、數據報告和分析。它幫助SQL開發人員管理數據庫，在流行的源代碼管理系統中版本控制數據庫的更改，加快日常任務的執行速度，以及進行復雜的數據庫更改。

dbForgeStudioforSQLServer提供了以下好處：

索引管理器

一個方便的工具，用於分析SQL索引的狀態，並解決索引碎片化的問題。索引管理器允許您快速收集索引碎片統計信息並檢測需要維護的數據庫。您可以在可視化模式下立即重建和重新組織SQL索引，或者生成SQL腳本以供將來使用。

單元測試

用於實現自動化單元測試的直觀和方便的工具。該工具基於開源TSQLT框架，因此SQL開發人員可以從用常規T-SQL編寫單元測試中獲益。單元測試豐富的功能允許開發穩定可靠的代碼，可以在單元級別進行正確的回歸測試。

Description:
dbForgeStudioforSQLServerisapowerfulIDEforSQLServermanagement,administration,development,datareportingandanalysis.IthelpsSQLdeveloperstomanagedatabases,version-controldatabasechangesinpopularsourcecontrolsystems,speeduproutinetasks,aswell,astomakecomplexdatabasechanges.

AhandytoolforanalyzingthestatusofSQLindexesandfixingissueswithindexfragmentation.IndexManagerallowsyoutoquicklycollectindexfragmentationstatisticsanddetectdatabasesthatrequiremaintenance.YoucaninstantlyrebuildandreorganizeSQLindexesinvisualmodeorgenerateSQLscriptforfutureuse.

Energizedatabasedevelopment.

dbForgeStudioforSQLServerisapowerfulIDEforSQLServermanagement,administration,development,datareportingandanalysis.IthelpsSQLdeveloperstomanagedatabases,version-controldatabasechangesinpopularsourcecontrolsystems,speeduproutinetasks,aswell,astomakecomplexdatabasechanges.

dbForgeStudioforSQLServerprovidesthefollowingbenefits:

IndexManager
AhandytoolforanalyzingthestatusofSQLindexesandfixingissueswithindexfragmentation.IndexManagerallowsyoutoquicklycollectindexfragmentationstatisticsanddetectdatabasesthatrequiremaintenance.YoucaninstantlyrebuildandreorganizeSQLindexesinvisualmodeorgenerateSQLscriptforfutureuse.

UnitTest
Anintuitiveandconvenienttoolforimplementingautomatedunittesting.Thetoolisbasedontheopen-sourcetSQLtframework,soSQLdeveloperscanbenefitfromwritingunittestsinregularT-SQL.UnitTestrichfunctionalityallowstodevelopstableandreliablecodethatcanbeproperlyregressiontestedattheunitlevel.

SQLCodingAssistance
-Codecompletion-tocreatewholeSQLstatementinafewkeystrokes.
-SQLformatting-tofollowcommoncodingstyle(standard).
-SQLsnippets-tosavetimestoringandreusingrepeatedcodefragments.
-Quickobjectinformation-toshowhintswithinfoondatabaseobjects.
-Codenavigation-quickjumpbyF12tovariabledeclaration,objecteditor,etc.

SQLSourceControl
-Linkyourdatabasestomostpopularsourcecontrolsystems.
-Source-controlaworkingfolder.
-Performallsource-controllingtasksvisually.
-Trackchangeshistory.
-Resolveconflicts.

TableDesigner
-Quicklysettablepropertiesinthevisualeditors.
-Editascriptthatcreatesthetable.
-Rebuildtableswhencomplexchangesareintroduced.
-Previewchangesbeforemodificationofadatabaseobject.

DatabaseDiagram
-Easymanipulationandscaling.
-Containersforgroupingobjects.
-Printinglargediagrams.
-Virtualconnections.

SchemaCompare
-Synchronizedatabaseschemaswithcomplexobjectdependencies.
-Detectdevelopmenterrorsearly.
-Createschemasnapshotstocapturedatabasestructure.
-Detectdriftonproductiondatabases.
-CreatedeploymentscriptstargetingdifferentSQLServereditions.

-T-SQLDebugger[/b]-QueryProfiler

QueryBuilder
-Createcomplexqueriesinasplitsecondusingonlythemouse.QueryBuildertoolcomprisesvisualeditorsforeachqueryclause,automaticallycreatesrelationsbetweentables,allowsyoutoworkwithsubqueriesandeditINSERT,UPDATE,andDELETEqueriesvisually.

DataExportandImport
-Crucialtoolsforfillingadatabasewithexternalsourcedataandmigratingdatabetweensystems.Ourtoolssupport10+widelyuseddataformats,anumberofadvancedoptions,templatesforrecurringscenarios,customizableregularcommandlineimportandexport.

DataCompare
-Synchronizedatabetweenservers.
-Analyzedatadifferencesandcreatereports.
-Comparedatabaseswithdifferentstructure.
-Scheduleregulardatasynchronization.
-ComparetabledatainSQLServerbackups.

DataEditor
-UsingdbForgeStudioforSQLServertoolyouwillenjoyworkingwithtabulardata.Thistoolprovidesyouwithconvenientediting,filtering,sorting,copyingofrandomlyselectedcells,quickdataexporttoINSERTqueryandmanyotherfeaturesforabetterefficiency.

DataReports
-VisualDataReportdesignerwithsupportofchartplottingconvertsyourdataintoagood-lookingreport.Thistoolalsoallowsyoutogenerateareportin9differentformats.Thecommandlineinterfacehelpsyoutoscheduleautomaticreportdelivery.

SecurityManager
-Visualeditorsforlogins,users,androles.
-Batcheditingofobjects.
-Setupprivilegesperschemaobject.

Master-DetailBrowser
-Usedforsimultaneousdataviewinrelatedtables.Itisalsoconvenientforexpressdataanalysisandlocatingspecificrecordsandlogicalerrorsinthedatabase.Visualdiagramhelpstosetupcommunicationsinafewsecondsandgodirectlytoview.

PivotTable
-Usingthistool,youdon'tneedtogointoSQLsubtletiestogroupandsummarizeyourdata.VisualPivotTableDesigner,advancedfiltering,visualdatapresentationinagraphmakeyourdataeasiertoread,understand,andanalyze.Note:tabledesignerdoesnotgeneratepivotSQLqueriesthatcanbeusedoutsideoftheprogram.

SystemRequirements:
OS:MicrosoftWindows10,MicrosoftWindows8.1,MicrosoftWindows8,MicrosoftWindows7
MicrosoftSQLServerConnectivity:
-SQLServer2019
-SQLServer2017
-SQLServerinstalledonLinux
-SQLServer2016SP1
-SQLServer2016
-SQLServer2014
-SSQLServer2012
-SQLServer2008,2008R2(includingExpressedition)
-SQLServer2005(includingExpressedition)
-SQLServer2000(includingMSDEedition)
-LocalDB
-SQLAzure
-WorkingwithSQLServeronAmazonRDS
-AzureSQLDataWarehouse

dbForgeStudio2019forSQLServerv5.8.107EnterpriseEdition

Homepage
https://www.devart.com/