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.