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
- Integration with Visual Studio
- SQL Server Connectivity
- Administration
- Integration with dotConnect for SQL Server
- Data Analysis
- Data Comparison
- Data Editor
- Database Explorer
- Database Search
- Exporting and Importing Data
- Object Editors
- Query Builder
- Query Profiler
- Security Manager
- Schema Comparison
- SQL Editing and Execution
- T-SQL Debugger
- Visual Database Diagram
- All database development and administration tasks available from your IDE
- SQL Editor, database object editors and other editors behave like usual IDE documents
- 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
- Database backup
- Database restore
- Copy database
- Database attach
- Database detach
- Drag'n'drop objects onto form and dataset designers
- Component editors extended with additional commands
- Master-detail data browser
- Data report generation wizard
- Data report designer
- Pivot table designer
- Chart building wizard
- 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
- 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
- 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
- Data search on a live database
- Schema object search by name
- Schema object search by substring of DDL text
-
Data export to:
- CSV
- XML
- Text
- XLS
- 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
- 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)
- 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
- 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
Visual editors for the security principal objects:
- Login
- User
- Role
- Application Role
- 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 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
- 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
- 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