dbForge Fusion for SQL Server

This is a Visual Studio plug-in that simplifies development using SQL Server.

dbForge Fusion for SQL Server is a Visual Studio plugin designed to simplify SQL database based development. It helps enhance data-management capabilities. The benefit of integrating this plug-in into Microsoft Visual Studio is that you are able to access database development and administration tasks from the IDE. That can make it easier to explore and maintain existing databases, design compound SQL statements and queries, and manipulate data. All the tasks related to SQL database management, and administration can be carried out from the Microsoft Visual Studio environment. The features available include SQL Coding Assistance, automatic code completion, code snippets, quick information on schema objects, document outline for navigation, formatting of SQL code, etc. The T-SQL debugger is integrated into the stored procedure editor. Debugging is simplified. You can simply click on the database explorer tree and get a debug session started.

Database diagramming feature helps you get familiar with a database structure quickly. This feature will let you drag & drop the database on the diagram and get its basic objects and their connections clearly displayed. The flat table editor will let you set table properties in the visual editors. Scripts that create tables can be edited, rebuilt, and previewed are available. SQL query profiler will let you pinpoint bottlenecks and optimize slow query execution time with several available options. SQL changes can be managed, synchronization of table data between servers carried out, comparison of data difference and report creation; data sync, etc. are possible. Import and export of data in many formats can take place. Flexible report generation options supported by charting feature are available. This is a very good tool.

dbForge Fusion for SQL Server is a powerful Visual Studio plugin. It fully integrates into Microsoft Visual Studio making all database development and administration tasks available from your IDE. One installation file serves for installing the plugin into Visual Studio 2010 / 2012 / 2013 - users just need to check the needed IDE during installation.
Key features:
- Integration with Visual Studio 2010, 2012, 2013
- Integration with dotConnect for SQL Server
- Data Analysis
- SQL Connectivity
* Microsoft SQL Server versions from 2000 to 2014, Microsoft SQL Azure and Amazon RDS are supported.
- Data Comparison
*Comparing and synchronizing data in databases of virtually any size
*Comparison of tables, views, and custom queries
*Data synchronization script generation
*Viewing differences on each record of data
*Excluding tables and records from synchronization
*Generating precise comparison reports in HTML and Excel formats
- Data Editor
*Non-synchronous data fetch with possibility to cancel the operation
*Customizable data filters of any level of complexity
*Foreign key lookup editor for easy editing of fields referencing other tables
*Quick building of report, chart, and pivot table directly from data editor
*Large objects (LOB) editor
- Database Explorer
- Database Search
- Exporting and Importing Data
- Object Editors
- Query Builder
- Query Profiler
- Security Manager
- Schema Comparison
*Ability to compare and synchronize SQL Server database schemas
*Synchronization between different server versions
*Ability to generate schema comparison reports
*Schema synchronization script generation
- SQL Editing and Execution
- Smart SQL Server Code Completion
- SQL Formatter
- SQL Code Refactoring
- T-SQL Debugger
- Visual Database Diagram