dbForge Fusion for SQL Server Features

Devart's add-in for SQL Server provides a number of tools for SQL database development and data management. This page provides a comprehensive listing of features available in dbForge Fusion for SQL Server. For a list of new features, see What's New in 1.8.

Table of Contents

  1. Integration with Visual Studio
  2. SQL Server Connectivity
  3. Administration
  4. Integration with dotConnect for SQL Server
  5. Data Analysis
  6. Data Comparison
  7. Data Editor
  8. Database Explorer
  9. Database Search
  10. Exporting and Importing Data
  11. Object Editors
  12. Query Builder
  13. Query Profiler
  14. Security Manager
  15. Schema Comparison
  16. SQL Editing and Execution
  17. T-SQL Debugger
  18. Visual Database Diagram

Integration with VS

Integration with Visual Studio

  • All database development and administration tasks available from your IDE
  • SQL Editor, database object editors and other editors behave like usual IDE documents

SQL Server Connectivity

SQL Server Connectivity

  • Microsoft SQL Server 2014 New
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2008, 2008R2 (including Express edition)
  • Microsoft SQL Server 2005 (including Express edition)
  • Microsoft SQL Server 2000
  • Microsoft SQL Azure
  • Amazon RDS for Microsoft SQL Server

Administration

Administration

  • Database backup
  • Database restore
  • Copy database
  • Database attach
  • Database detach

SQL Connectivity

Integration with dotConnect for SQL Server

  • Drag'n'drop objects onto form and dataset designers
  • Component editors extended with additional commands

SQL Connectivity

Data Analysis

  • Master-detail data browser
  • Data report generation wizard
  • Data report designer
  • Pivot table designer
  • Chart building wizard

SQL Connectivity

Data Comparison

  • Comparing and synchronizing data in databases of virtually any size
  • Comparison of tables, views, and custom queries
  • Custom comparison keys support
  • Comparison results filtering
  • Data synchronization script generation
  • Viewing differences on each record of data
  • Excluding tables and records from synchronization
  • Ability to save and load comparison settings
  • Generating precise comparison reports in HTML and Excel formats

SQL Connectivity

Data Editor

  • Non-synchronous data fetch with possibility to cancel the operation
  • Batch updates for tables when changes are accumulated and applied explicitly
  • Ability to copy data with column headers for quick pasting to spreadsheet
  • Customizable data filters of any level of complexity
  • Data Viewer window for viewing images, rtf, and binary cell values
  • Date time editor with visual UI
  • Foreign key lookup editor for easy editing of fields referencing other tables
  • Ability to copy any block of data to clipboard
  • Full-text search (Ctrl+F) in data grid
  • Graphical card view
  • Grouping by user-defined columns
  • Step-by-step search (Ctrl+I) through data grid
  • Large objects (LOB) editor
  • Multi-table query result set editing
  • Paginal data browsing for large result sets
  • Printing of data
  • Quick filter for each data cell is available
  • Record numbering option
  • Read-only status indication
  • Quick building of report, chart, and pivot table directly from data editor
  • Server-side sorting and filtering to help dealing with large data sets
  • Visible columns picking dialog box
  • Ability to edit several execution results of one script on separate tabs

SQL Connectivity

Database Explorer

  • Multiple database connections are available
  • Non-synchronous connecting to server with possibility to cancel the operation
  • Detailed object properties and data viewing in Object Viewer window
  • Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc.
  • 'Send To' command for quick sending of tables to Query Builder, Data Report, and other tools
  • Quick access to object privileges (GRANT) from the popup menu
  • Group-selection for batch operations on objects
  • Navigation history for database
  • Connection coloring and categories

SQL Connectivity

Database Search

  • Data search on a live database
  • Schema object search by name
  • Schema object search by substring of DDL text

SQL Connectivity

Exporting and Importing Data

  • Data export to:
    • CSV
    • XML
    • Text
    • XLS
    • PDF
    • DBF
    • HTML
    • RTF
    • MDB (Access)
    • ODBC
    • SQL
  • Export data from multiple tables at once
  • Data import from:
    • CSV
    • XML
    • Text
    • XLS
    • XLSX
    • DBF (Foxpro, dBase III, dBase IV, dBase 7)
    • MDB (Access)
    • ODBC
  • Templates for exporting and importing

SQL Connectivity

Object Editors

  • Database visual editor
  • Visual editors for the following schema object types:
    • Check constraint
    • Foreign key
    • Index
    • Table
    • Unique key
  • Source-based editors for the following schema object types:
    • Sequence
    • Stored function
    • Stored procedure
    • Synonym
    • Trigger
    • View
  • Ability to preview changes before database modification
  • Undo option for object editor
  • Ability to browse schema objects in a single editor (pin document)

SQL Connectivity

Query Builder

  • Support building SELECT, INSERT, UPDATE, and DELETE statements
  • The state-of-art diagram with zooming and keyboard support
  • Preview and printing of the diagram
  • Visual addition of sub-queries to any part of the main query
  • Query outline (displayed in Document Outline window)
  • Visual editing of sub-queries
  • Expression builder for creating complex conditions
  • Copy/Paste for tables on the diagram
  • Undo/Redo support
  • Saving queries to a file

SQL Connectivity

Query Profiler

  • Ability to get estimated and actual execution plans
  • Plan diagram with visualization of expensive nodes
  • Plan tree that displays operations hierarchy and cost parameters
  • Top operations list that to sort operations by CPU and IO costs
  • Profiling history that can be saved for further analysis
  • Comparing of main query metrics with differences highlight
  • Profiling results printing

SQL Connectivity

Security Manager

Visual editors for the security principal objects:

  • Login
  • User
  • Role
  • Application Role

SQL Connectivity

Schema Comparison

  • Ability to compare and synchronize SQL Server database schemas
  • Ability to generate schema comparison reports
  • Synchronization between different server versions
  • Comparison of native SQL Server backups
  • Comparison filtering results
  • Schema synchronization script generation
  • Viewing of DDL differences on each object
  • Exclusion of objects from synchronization
  • Ability to save and load comparison settings

SQL Connectivity

SQL Editing and Execution

  • SQL editor with syntax coloring, bookmarks, and text search
  • Context-sensitive code completion
  • Code collapsing/expanding with support of user-defined regions
  • SQL formatting with rich options
  • SQL snippets library with a browser window and editor
  • Document Outline window for quick navigation through large scripts
  • Execution of scripts, selected SQL fragments, and statements
  • One-step access to a schema object editor from code (go to definition)
  • Parameter information for stored procedures and functions
  • Quick access to favorite templates from SQL editor
  • Quick information about schema objects
  • Executed SQL history window for the document

SQL Connectivity

T-SQL Debugger

  • Quick debugger launch from Database Explorer
  • Step Into, Step Over, and Step Out commands for step-by-step execution
  • Breakpoints support for procedures, functions, triggers, and scripts
  • Breakpoints window
  • Call Stack window with navigation
  • Watches window for variable evaluation

SQL Connectivity

Visual Database Diagram

  • Visualization of tables, views, stored procedures
  • Easy access to database objects for viewing their properties, editing, retrieving data, executing stored routines, etc.
  • Support for IDEF1X and IE notations
  • Customizable diagram look and feel with skin support
  • Smart diagram layout
  • Diagram export to different image formats
  • Searching database objects on diagram
  • Organizing diagram shapes with containers
  • Customizable diagram printing with a rich set of options
  • Optional displaying of table constraints, indexes, and triggers
  • Integration with Document Outline window
  • Diagram navigation with Diagram Overview window
  • Notes for adding your comments to the diagram