dbForge Studio for SQL Server Features Overview

Writing code in SQL Editor takes lot of time while you can be more productive with the help of:

• Code completion — to create whole SQL statement in a few keystrokes.
• SQL formatting — to follow common coding style (standard).
• T-SQL Analyzer — to improve quality of your code with configurable rules.
• SQL snippets — to save time storing and reusing repeated code fragments.
• Quick object information — to show hints with info on database objects.
• Code navigation — to quickly jump by F12 to variable declaration, object editor, etc.

Previously, only SQL Complete included the above features, and now they are a part of dbForge Studio for SQL Server.

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 a visual mode or generate SQL script for future use.

Table is a key object in any database and is the most difficult one to configure. The elaborated SQL Table Designer allows to:

• 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 an SQL database object.

A must-have SQL database development tool for server-side logic. It's integrated into the stored procedure editor. Start debugging by clicking on the Database Explorer tree.

Give the Schema Compare a try, and you will use this tool for any major changes in the database structure. Our tool will help you to:

• Synchronize database schemas with complex object dependencies.
• Detect development errors early.
• Create schema snapshots to capture database structure.
• Detect drift on production databases.
• Create deployment scripts targeting different SQL Server editions.

Learn More

A powerful tool for generating large volumes of meaningful test data for SQL Server database tables. The tool includes a great choice of predefined generators with sensible configuration options, that allow emulating column-intelligent real-world data.

• 200+ meaningful generators
• 15+ Basic generators
• User-defined generators
• Command-line interface

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.

With Security Manager integrated into dbForge Studio for SQL Server, you can administer your database confidently and safely. It allows you to:

• Manage users accounts and logins.
• Assign roles to users if they have a whole set of privileges.
• Grant and revoke users permissions.

Using the SQL Server manager, you will enjoy managing 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.

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.

Transfer SQL Server databases from one sever to another with a handy wizard. The Copy Database wizard provides:

• Customizable transfer settings
• Smart errors handling
• Saving copy projects for the future use

Learn More

With this feature, you can quickly and easily detect, fix, and analyze invalid objects that often appear during the database development process. dbForge Studio for SQL Server allows searching for objects that cannot be compiled or executed as well as generating effective scripts to manage them. The functionality provides the following opportunities:

• Searching and locating invalid objects through multiple databases
• Analyzing and reporting the search results
• Managing the objects through Script as ALTER and Script as DROP buttons
• Convenient navigation through the Find Invalid Objects grid