Resolve

issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

Data Editor

  • Asynchronous data fetch with ability to cancel the operation
  • Batch table update mode when changes are accumulated and applied explicitly
  • Copying data with column headers for quick paste to spreadsheet
  • Custom data filters of any complexity
  • Data Viewer and Editor window for browsing and editing large objects
  • Date time editor with visual interface
  • Foreign key lookup editor for easy editing of fields referencing other tables
  • Full-text search (Ctrl+F) through data grid
  • Graphical card view
  • Grouping by arbitrary columns
  • Incremental search (Ctrl+I) through data grid
  • Multi-table query result set editing
  • Paginated data browsing for large result sets
  • Server-side sorting and filtering to help dealing with large data sets
  • Visible columns picking dialog box
  • Editing microseconds in columns with the TIME, DATETIME and TIMESTAMP data types

Database Explorer

  • Multiple database connections allowed
  • Asynchronous connect to server with ability to cancel the operation
  • Detailed object properties and data browsing in Object Viewer window
  • Quick script generation for an object: SELECT, INSERT, EXECUTE, etc
  • 'Send To' command for quick sending of tables to Query Builder
  • Multi-selection for batch operations on objects
  • Database navigation history

Exporting Data

  • Data export to: JSON, CSV, XML, Text, XLS, PDF, DBF, HTML, RTF, MDB (Access), ODBC, and SQL
  • Export data from multiple tables at once

Query Builder

  • 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
  • Undo/Redo support
  • Support of visual building of INSERT, UPDATE, and DELETE statements
  • Conversion of SELECT queries into INSERT statements
  • One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition

Query Profiler

  • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI
  • Plan of the query displayed in the tree view for easy review
  • Profiling history that can be saved for further analysis
  • Compare profiling results feature with differences highlight
  • Profiling results printing

SQL Editing and Execution

  • Automatic SQL syntax check
  • Context-sensitive code completion
  • Document Outline window for quick navigation through large scripts
  • Execution of scripts, selected SQL fragments, and statements
  • Quick information about schema objects
  • SQL editor with syntax coloring, bookmarks, and text searching
  • SQL formatting on-the-fly in the editor
  • Executed SQL history window for the document
  • Wizard for batch SQL formatting of files on the disk

User Interface

  • Rich user settings
  • UI skins
  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Syntax highlight customization
  • Tabbed groups for documents
  • Toolbars customization
  • Ability to browse schema objects in a single editor (pin document option)