dbForge Studio for SQL Server 5.5

dbForge Studio for SQL Server is a Business::Databases & Tools software developed by Devart. After our trial and test, the software was found to be official, secure and free. Here is the official description for dbForge Studio for SQL Server: dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help 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. Key Features: * Tool for source-controlling SQL databases * Data Generator. More than 180 meaningful data generators, user-defined generator etc * 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 * Schema Compare allows to synchronize database schemas with complex object dependencies; Detect development errors early; create schema snapshots to capture database structure etc. * T-SQL Code Analyzer * Visual Index Editor * Custom mapping for objects by their names * Server Events Profiler * T-SQL Debugger * 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 tool for transferring data between servers * 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 * Index Manager * Unit Test tool * Source Control * SQL Server 2016 support *Database Search (objects and data) *Data Editor, Viewer Window *Documenter for SQL Server tool

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 source-control databases, speed up routine tasks, as well, as to make complex database changes.

Key Features*:

• SQL Coding Assistance - code completion and formatting, SQL snippets, quick info and navigation.
• SQL Server Data Generator support.
• Source Control feature allows you to seamlessly integrate source control into your database development process.
• 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.

* These are the features of the Enterprise edition. If you are interested in another product edition, please check the 'Editions' page of the corresponding product.

What's New in dbForge Studio for SQL Server 5.5 [see older]

Executed SQL Statements History, Support for Surround SCM predefined template, SQL Server 2016 Service Pack 1 (SP1) and SQL Server 2017 CTP2.0 new syntax support.