dbForge Studio for SQL Server是一個強大的IDE，用於SQL服務器管理、管理、開發、數據報告和分析。它幫助SQL開發人員管理數據庫，在流行的源代碼管理系統中版本控制數據庫的更改，加快日常任務的執行速度，以及進行復雜的數據庫更改。
一個方便的工具，用於分析SQL索引的狀態，並解決索引碎片化的問題。索引管理器允許您快速收集索引碎片統計信息並檢測需要維護的數據庫。您可以在可視化模式下立即重建和重新組織SQL索引，或者生成SQL腳本以供將來使用。
為數據庫開發註入活力。
dbForge Studio for SQL Server是一個強大的IDE，用於SQL服務器管理、管理、開發、數據報告和分析。它幫助SQL開發人員管理數據庫，在流行的源代碼管理系統中版本控制數據庫的更改，加快日常任務的執行速度，以及進行復雜的數據庫更改。
dbForge Studio for SQL Server提供了以下好處：
索引管理器
一個方便的工具，用於分析SQL索引的狀態，並解決索引碎片化的問題。索引管理器允許您快速收集索引碎片統計信息並檢測需要維護的數據庫。您可以在可視化模式下立即重建和重新組織SQL索引，或者生成SQL腳本以供將來使用。
單元測試
用於實現自動化單元測試的直觀和方便的工具。該工具基於開源T SQL T框架，因此SQL開發人員可以從用常規T-SQL編寫單元測試中獲益。單元測試豐富的功能允許開發穩定可靠的代碼，可以在單元級別進行正確的回歸測試。
Description:
dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. It helps SQL developers to manage databases, version-control database changes in popular source control systems, speed up routine tasks, as well, as to make complex database changes.
A handy tool for analyzing the status of SQL indexes and fixing issues with index fragmentation. Index Manager allows you to quickly collect 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 future use.
Energize database development.
dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. It helps SQL developers to manage databases, version-control database changes in popular source control systems, speed up routine tasks, as well, as to make complex database changes.
dbForge Studio for SQL Server provides the following benefits:
Index Manager
A handy tool for analyzing the status of SQL indexes and fixing issues with index fragmentation. Index Manager allows you to quickly collect 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 future use.
Unit Test
An intuitive and convenient tool for implementing automated unit testing. The tool is based on the open-source tSQLt framework, so SQL developers can benefit from writing unit tests in regular T-SQL. Unit Test rich functionality allows to develop stable and reliable code that can be properly regression tested at the unit level.
SQL Coding Assistance
-Code completion - to create whole SQL statement in a few keystrokes.
-SQL formatting - to follow common coding style (standard).
-SQL snippets - to save time storing and reusing repeated code fragments.
-Quick object information - to show hints with info on database objects.
-Code navigation - quick jump by F12 to variable declaration, object editor, etc.
SQL Source Control
-Link your databases to most popular source control systems.
-Source-control a working folder.
-Perform all source-controlling tasks visually.
-Track changes history.
-Resolve conflicts.
Table Designer
-Quickly set table properties in the visual editors.
-Edit a script that creates the table.
-Rebuild tables when complex changes are introduced.
-Preview changes before modification of a database object.
Database Diagram
-Easy manipulation and scaling.
-Containers for grouping objects.
-Printing large diagrams.
-Virtual connections.
Schema Compare
-Synchronize database schemas with complex object dependencies.
-Detect development errorsearly.
-Create schema snapshots to capture database structure.
-Detect drift on production databases.
-Create deployment scripts targeting different SQL Server editions.
-T-SQL Debugger[/b] -Query Profiler
Query Builder
-Create complex queries in a split second using only the mouse. Query Builder tool comprises visual editors for each query clause, automatically creates relations between tables, allows you to work with subqueries and edit INSERT, UPDATE, and DELETE queries visually.
Data Export and Import
-Crucial tools for filling a database with external source data and migrating data between systems. Our tools support 10+ widely used data formats, a number of advanced options, templates for recurring scenarios, customizable regular command line import and export.
Data Compare
-Synchronize data between servers.
-Analyze data differences and create reports.
-Compare databases with different structure.
-Schedule regular data synchronization.
-Compare table data in SQL Server backups.
Data Editor
-Using dbForge Studio for SQL Server tool you will enjoy working with tabular data. This tool provides you with convenient editing, filtering, sorting, copying of randomly selected cells, quick data export to INSERT query and many other features for a better efficiency.
Data Reports
-Visual Data Report designer with support of chart plotting converts your data into a good-looking report. This tool also allows you to generate a report in 9 different formats. The command line interface helps you to schedule automatic report delivery.
Security Manager
-Visual editors for logins, users, and roles.
-Batch editing of objects.
-Setup privileges per schema object.
Master-Detail Browser
-Used for simultaneous data view in related tables. It is also convenient for express data analysis and locating specific records and logical errors in the database. Visual diagram helps to set up communications in a few seconds and go directly to view.
Pivot Table
-Using this tool, you don't need to go into SQL subtleties to group and summarize your data. Visual Pivot Table Designer, advanced filtering, visual data presentation in a graph make your data easier to read, understand, and analyze. Note: table designer does not generate pivot SQL queries that can be used outside of the program.
System Requirements:
OS:Microsoft Windows 10,Microsoft Windows 8.1,Microsoft Windows 8,Microsoft Windows 7
Microsoft SQL Server Connectivity:
-SQL Server 2019
-SQL Server 2017
-SQL Server installed on Linux
-SQL Server 2016 SP1
-SQL Server 2016
-SQL Server 2014
-SSQL Server 2012
-SQL Server 2008, 2008R2 (including Express edition)
-SQL Server 2005 (including Express edition)
-SQL Server 2000 (including MSDE edition)
-Local DB
-SQL Azure
-Working with SQL Server on Amazon RDS
-Azure SQL Data Warehouse
dbForge Studio 2019 for SQL Server v5.8.107 Enterprise Edition
Homepage
https://www.devart.com/
|
專業軟體光碟
