dbForge Studio for SQL Server Standard

dbForge Studio for SQL Server represents an IDE for developing and administering projects in SQL Server. It supports data reporting and analysis tools for pro-level users.

During installation, the app offers to associate itself with SQL scripts (.sql, Master-Detail files (.mdet), Database Diagrams (.dbd), Data Reports (.rdb), Data comparison files (.dcomp), Schema comparison files (.scomp), Database schema snapshot files (.snap), Data generation files (.dgen) and Server events profiles files (.ssp).

It has a startup optimization component that uses the standard Ngen.exe utility to boost the performance of .NET-based applications. This module is capable of generating images for all assemblies during installation or for those running in the background.

dbForge Studio for SQL Server is wrapped in a clean and comprehensive interface with a neatly organized layout for professional users. The multi-tabbed window puts a query builder at your disposal for dropping objects from the database explorer to easily run selection, join, where, group by, having and order by scripts.

Other viewers are available for editing queries and data, analyzing query performance, the document outline, inserting code snippets, and examining output results (e.g. SQL log, debugging).

The database can be backed up and restored. You can generate scripts, put together a scripts folder or snapshot, manage index fragmentation, locate object names, DDLs or table data items using a search tool, as well as import and export data (e.g. HTML, Excel, CSV, XML).

The program features tools for formatting SQL files and directories, managing snippets, and creating reports from profile server events. It's possible to customize the toolbars and commands, switch to another GUI skin, and remap keyboard shortcuts.

To sum it up, dbForge Studio for SQL Server comes equipped with advanced options packed in a user-friendly interface for working in SQL Server.