dbForge Studio for SQL Server –来自Devart的Ultimate SQL Server Manager工具

╰半橙微兮° 2022-12-08 04:48 114阅读 0赞

[dbForge Studio for SQL Server][] is an integrated environment for managing, administering, accessing, configuring, and developing SQL Server. The tool consists of various graphical utilities and script editors that provide developers and administrators of all skill levels the opportunity to access and manage SQL Server. You can [download][] the latest version of dbForge Studio for SQL Server from the Devart website.

[dbForge Studio for SQL Server][]是用于管理，管理，访问，配置和开发SQL Server的集成环境。 该工具由各种图形实用程序和脚本编辑器组成，它们为各种技能水平的开发人员和管理员提供了访问和管理SQL Server的机会。 您可以从Devart网站[下载][download]最新版本的dbForge Studio for SQL Server。

**Features highlights**

**功能亮点**

dbForge Studio for SQL Server provides a rich environment for managing and developing queries in SQL Server:

dbForge Studio for SQL Server提供了一个丰富的环境来管理和开发SQL Server中的查询：

**SQL Coding Assistance** features help you to learn more about the SQL code you are using, keep track of the parameters you are typing with only a few keystrokes. Automatic SQL formatting allows you to follow common coding style standards. The tool provides a great number of built-in SQL snippets that save your time allowing you to store and reuse repeated code fragments. Quick Object Info displays the complete description for any identifier in your code.

**SQL Coding Assistance**功能可帮助您了解有关正在使用SQL代码的更多信息，只需单击几次键即可跟踪所键入的参数。 自动SQL格式设置使您可以遵循常见的编码样式标准。 该工具提供了大量内置SQL代码段，可节省您的时间，使您可以存储和重复使用重复的代码片段。 快速对象信息显示代码中所有标识符的完整描述。

![dbForge 1][]

**SQL Source Control** allows you to version controlling your database development and deployment processes. It takes a few seconds to link an SQL database to one of the supported source control systems: Subversion (SVN), Team Foundation Server (including TFS Cloud), Git (including GitHub), Perforce (P4), Mercurial, SourceGear Vault. Thus, you can source-control an SQL database working folder in the same way as you version-control other files. The tool allows you to commit your local changes to a remote repository as well as update the local working copy with the latest changes from the source control. In case you face with a conflict, you can resolve it visually in a handy interface.

**SQL Source Control**允许您对数据库开发和部署过程进行版本控制。 将SQL数据库链接到受支持的源代码控制系统之一需要花费几秒钟的时间：Subversion(SVN)，Team Foundation Server(包括TFS Cloud)，Git(包括GitHub)，Perforce(P4)，Mercurial，SourceGear Vault。 因此，您可以以与版本控制其他文件相同的方式对SQL数据库工作文件夹进行源控制。 该工具允许您将本地更改提交到远程存储库，并使用源控件中的最新更改来更新本地工作副本。 如果遇到冲突，可以在方便的界面中以视觉方式解决它。

![dbForge 2][]

Built-in **Index Manager** lets you to analyze the status of SQL indexes and fix issues with index fragmentation. The tool lets you to quickly gather index fragmentation statistics and detect databases that require maintenance. You can instantly rebuild and reorganize SQL indexes in visual mode or generate SQL script for the future use.

内置的**索引管理**器使您可以分析SQL索引的状态并解决索引碎片的问题。 该工具使您可以快速收集索引碎片统计信息并检测需要维护的数据库。 您可以在可视模式下立即重建和重新组织SQL索引，或生成SQL脚本以备将来使用。

![dbForge 3][]

**Unit Test** is a tool, based on the open-source tSQLt framework, for implementing automated unit testing. Thus, you can develop stable and reliable SQL code that can be properly regression tested at the unit level.

**单元测试**是基于开源tSQLt框架的工具，用于实现自动化的单元测试。 因此，您可以开发稳定可靠SQL代码，并可以在单元级别进行适当的回归测试。

![dbForge 4][]

**Table Designer** looks very familiar to one in SSMS. It provides you visual editors for column, index, primary and foreign keys, check constraints, statistics, and table storage properties.

在SSMS中， **Table Designer**看起来非常熟悉。 它为列，索引，主键和外键，检查约束，统计信息和表存储属性提供了可视化编辑器。

![dbForge 5][]

Built-in **Database Diagram** tool helps you to visualize a database. You can create one or more diagrams that illustrates several or all tables, columns, keys, and relationships in the particular database. dbForge Studio for SQL Server allows you to create as many database diagrams as you want. Every table may be added on any number of diagrams, which allow you to create different diagrams to visualize different parts of the database.

内置的**数据库图**工具可帮助您可视化数据库。 您可以创建一个或多个图，以说明特定数据库中的多个或所有表，列，键和关系。 dbForge Studio for SQL Server允许您创建所需数量的数据库图。 每个表都可以添加到任意数量的图上，这使您可以创建不同的图以可视化数据库的不同部分。

![dbForge 6][]

**Query Profiler** supplies you with graphical representation of actual and estimated query execution plans. Graphical plans are commonly used type of execution plan. They are quick and easy to read. You can view both estimated and actual execution plans in graphical format and the graphical structure makes understanding most plans very easy. The detailed data for the plan is hidden behind ToolTips and Property sheets. The tool allows you to compare different plans while doing some performance tuning.

**Query Profiler**为您提供实际和估计的查询执行计划的图形表示。 图形计划是执行计划的常用类型。 它们快速且易于阅读。 您可以以图形格式查看估计的和实际的执行计划，并且图形结构使理解大多数计划变得非常容易。 该计划的详细数据隐藏在“工具提示”和“属性”表的后面。 该工具使您可以在进行一些性能调整时比较不同的计划。

![dbForge 7][]

**Schema Compare** tool allows you to synchronize database schemas with complex object dependencies. When the schema comparison process finishes, its results appear in a window. In addition, dbForge Studio for SQL Server generates a Data Definition Language (DDL) script that you can use to synchronize the different schemas.

**使用架构比较**工具，您可以将数据库架构与复杂的对象依赖项进行同步。 模式比较过程完成后，其结果将显示在窗口中。 此外，用于SQL Server的dbForge Studio还会生成一个数据定义语言(DDL)脚本，您可以使用该脚本来同步不同的架构。

![dbForge 8][]

In case you need to transfer data from one SQL Server instance to another, or to compare databases with different structures on two remote SQL Server instances, the **Data Compare** tool is what you need. With this tool, you can easy synchronize table data between servers, analyze data differences and create reports. You can even schedule regular data synchronization and automate the process.

如果您需要将数据从一个SQL Server实例传输到另一个实例，或者比较两个远程SQL Server实例上具有不同结构的数据库，则需要**数据比较**工具。 使用此工具，您可以轻松地在服务器之间同步表数据，分析数据差异和创建报告。 您甚至可以安排定期的数据同步并自动执行该过程。

![dbForge 9][]

While developing applications, it is a challenge to perform testing under conditions that closely simulate production environment. If you do not have meaningful test data in test environment, it is not possible to determine the way the application will behave after the release. Built-in **Data Generator** provides s a great choice of predefined generators with sensible configuration options that allow emulating column-intelligent and meaningful data.

在开发应用程序时，在严密模拟生产环境的条件下进行测试是一个挑战。 如果在测试环境中没有有意义的测试数据，则无法确定应用程序在发行后的行为方式。 内置的**数据生成器**提供了很多预定义的生成器，并带有明智的配置选项，可以模拟列智能和有意义的数据。

![dbForge 10][]

If you are not too proficient with T SQL, visual **Query Builder** will help you to create complex queries using only a mouse. The tool provides visual editors for each query clause and automatically creates relationships between tables.

如果您不太精通T SQL，可视化**查询生成器**将帮助您仅使用鼠标创建复杂的查询。 该工具为每个查询子句提供可视化编辑器，并自动在表之间创建关系。

![dbForge 11][]

Built-in **Event Profiler** allows you to capture and analyze SQL Server events. The events and data columns are stored in a physical trace file for later examination. You can use this information to identify and troubleshoot many SQL Server-related problems.

内置的**事件探查**器使您可以捕获和分析SQL Server事件。 事件和数据列存储在物理跟踪文件中，以供以后检查。 您可以使用此信息来识别和解决许多与SQL Server相关的问题。

![dbForge 12][]

With dbForge Studio for SQL Server you can easily build SQL reports of any complexity, edit report parameters, customize formatting, calculate summaries in the user-friendly interface of **SQL Server Report Builder**.

使用dbForge Studio for SQL Server，您可以在**SQL Server Report Builder**的用户友好界面中轻松构建各种复杂程度SQL报告，编辑报告参数，自定义格式，计算汇总。

![dbForge 13][]

**Conclusion** As you can see, dbForge Studio for SQL Server is a powerful sql manager tool that completely covers most of database developers’ and administrators’ needs. The important point is that the dbForge Studio for SQL Server is very affordable solution. Prices start from 249$, which is awesome!

**结束语** 如您所见，dbForge Studio for SQL Server是一个功能强大的sql管理器工具，可以完全满足大多数数据库开发人员和管理员的需求。 重要的一点是，dbForge Studio for SQL Server是非常实惠的解决方案。 价格从249美元开始，真棒！

> 翻译自: [https://www.thecrazyprogrammer.com/2016/03/dbforge-studio-sql-server.html][https_www.thecrazyprogrammer.com_2016_03_dbforge-studio-sql-server.html]

[dbForge Studio for SQL Server]: https://www.devart.com/dbforge/sql/studio/
[download]: https://www.devart.com/dbforge/sql/studio/download.html
[dbForge 1]: /images/20221123/1dd68a883f704c4cb357c0b84743e275.png
[dbForge 2]: /images/20221123/d277b13fa25747ea90d1bdc160ac331e.png
[dbForge 3]: /images/20221123/e0e8db1d16a340948e35aafafe594d13.png
[dbForge 4]: /images/20221123/64aa8667641841658706383eed0bffe5.png
[dbForge 5]: /images/20221123/16c89140ffcd427cab270b344422e50c.png
[dbForge 6]: /images/20221123/c4b2065479454d35ace89033d64d09b6.png
[dbForge 7]: /images/20221123/17a19865fa6a4a609c9750141d5f2ef6.png
[dbForge 8]: /images/20221123/9e91a1683d724ff4aee136cfcd3fb17e.png
[dbForge 9]: /images/20221123/69d90ef6b2314c3dbd2eebbc24245c4a.png
[dbForge 10]: /images/20221123/a694c78fffb74ab79a397b5e6f197594.png
[dbForge 11]: /images/20221123/cb0a3f88ead54d4b89d36ad97e631e4c.png
[dbForge 12]: /images/20221123/9e4c94bf53b54688816cd7c2891da73b.png
[dbForge 13]: /images/20221123/f5d49014a3d544198bb15b674e91b2a9.png
[https_www.thecrazyprogrammer.com_2016_03_dbforge-studio-sql-server.html]: https://www.thecrazyprogrammer.com/2016/03/dbforge-studio-sql-server.html