dbForge Fusion for SQL Server
Features Overview

• 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
  • 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

• 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