dbForge Studio for SQL Server is an integrated environment for SQL Server development, management, administration, data reporting and analysis. These SQL tools help developers to manage databases, speed up routine tasks, as well, as to make complex database changes.
* SQL Coding Assistance - code completion and formatting, SQL snippets, quick info and navigation.
* Table Designer allows to set table properties in the visual editors, edit scripts, rebuild tables and preview changes before modifying database objects.
* Database Diagram feature provides easy manipulation and scaling; containers for grouping objects; printing large diagrams; virtual connections etc.
* Schema Compare allows to synchronize database schemas with complex object dependencies; Detect development errors early; create schema snapshots to capture database structure; detect drift on production databases etc.
* T-SQL Debugger integrated into the stored procedure editor saves time when going through step by step code debugging.
* Query Profiler is an invaluable tool for detecting bottlenecks and optimization of slow query execution time.
* Query Builder - use visual editors to create queries fast with a mouse click.
* Database Management - create, edit, copy, attach, detach, generate script of SQL Server Database
* Data Export and Import tools for filling a database with external source data and migrating data between systems.
* Data Compare is an essential tool for transferring data between servers. It allows to sync table data between servers, analyze data differences and create reports, compare databases with different structure, schedule regular data synchronization etc.
* Data Editor streamlines your work by providing comfortable editing, filtering, sorting, copying of randomly selected cells, quick data export to INSERT query and many other features for a higher productivity.
* Data Report designer is capable to generate reports in 9 formats.
Recent Changes: * SQL Server 2014 support
* Database Backup and Restore features are added
* Generate Script of entire database
* Possibility to attach and detach a database is added
* Copying a database from one server to another using the MS Agent is possible now
* Database Visual Editor is added