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.
Features highlights
dbForge Studio for SQL Server provides a rich environment for managing and developing queries in 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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
Very useful review, thanks!