dbForge Query Builder for SQL Server 3.10

Advertising
Software information
Platform:
Windows Vista/XP/2000/Server
Publisher:
Devart
Price:
$99.95
File size:
18.21 Mb
Date added:
June 29, 2011
Screenshot:
Product page:
Description from the Publisher

dbForge Query Builder for SQL Server allows users to build complex SQL queries via an intuitive visual query building interface easily and without manual code writing. Our visual SQL query tool is destined for simplification of developing SQL queries for SQL Server. This SQL query designer will be useful to those, who often create queries to databases.

Visual features to create queries, usage of graphical SQL query creator to interactively build queries, would be most appreciated by users who have no experience in writing queries manually. But
even experienced users can save a lot of time on routine work.

Visual query diagram

Simply draw your query on the elaborated diagram instead of writing code manually. Drag’n’drop required tables to the diagram, join them, and select columns visually. For better view, use zooming options.

Creation of subqueries

Work with complex subqueries and manage them as simple queries with visual query building tool for SQL Server. Using the tabbed window, you can edit subqueries in separate windows and easily access the main query.

Designing DML queries

INSERT, DELETE, and UPDATE queries can be designed using dbForge Query Builder for SQL Server. The query type is stated on the label on the diagram. You can use this label to choose a table to work with.

Expression Editor

Automate your work with query criteria. See and visually edit them on the separate tabs under the diagram where you're drawing your query.

You don't need to type the columns' names or remember complex rules. Just select required data from the lists and enjoy the results.

SQL code beautifier

Query building tool for SQL Server will help when you are writing SQL code yourself or modifying existing code by suggesting possible variants for completing words and showing information on database objects.

Make your code formatting standard-driven using customizable profiles.

Visual query profiling

Leave behind challenging query profiling from the command line. Get EXPLAIN, SHOW PROFILE, and SHOW STATUS results in a convenient UI.

Select results for two query executions and get the differences highlighted.

Data management

Data management has become more convenient.

Group, sort, and filter data in the grid. For better data view and editing, use various modes. Benefit from cached updates and manage your data based on your needs. Moreover, you can print or export query results.

Foreign key lookup editor

Edit foreign keys directly in the data grid with the help of the Foreign key lookup editor. If the table you want to edit has foreign keys, just click the needed cell - and data of the parent table will be shown.

Data Export to 10 formats

Experience visual and accurate data export to 10 widely-used data formats: HTML, Text, MS Excel, MS Access, RTF, PDF, XML, CSV, DBF, ODBC. The export process is highly customizable and it is possible to use templates.

Features

Supported Microsoft SQL Server versions

  • SQL Server 2014
  • SQL Server 2012
  • SQL Server 2008, 2008R2 (including Express edition)
  • SQL Server 2005 (including Express edition)
  • SQL Server 2000
  • SQL Azure
  • Working with SQL Server on Amazon RDS

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
  • Free copying of any block of data to clipboard
  • 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
  • Paginal data browsing for large result sets
  • Printing of data
  • Quick filter feature available for each data cell
  • Record numbering option
  • Read-only state indication
  • 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 template script generation for selected 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:
    • CSV
    • XML
    • Text
    • XLS
    • PDF
    • DBF
    • HTML
    • RTF
    • MDB (Access)
    • ODBC
    • 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
  • Copy/Paste for tables on the diagram
  • Undo/Redo support
  • Saving queries to a file
  • 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)
Users reviews & testimonials

This software is not reviewed yet.

Advertising
Other downloads from this publisher

Entity Developer is a powerful visual model designer and code generation tool for LINQ to SQL.

dbForge Data Compare for Oracle is a powerful, fast, and easy tool for comparing and synchronizing Oracle databases. It helps you quickly compare data in tables, find the differences at a glance, and generate script to effortlessly synchronize data.

dbForge Studio for Oracle is a powerful IDE which helps developers to increase PL/SQL coding speed. It provides Oracle database management tools, allows to synchronize Oracle data and automate schema change management process during development.

Devart ODBC Driver for InterBase provides high-performance and feature-rich connectivity solution for ODBC-based applications to access InterBase databases from Windows, Linux, MacOS, both 32-bit and 64-bit.

Devart ODBC Driver for Firebird provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Firebird databases from Windows, Linux, MacOS, both 32-bit and 64-bit.