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.
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 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.
This software is not reviewed yet.
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.
Devart Excel Add-in for SQL Server allows you to use powerful Excel capabilities for processing and analysis of data from SQL Server or SQL Azure, editing external data as usual excel spreadsheets and saving data changes back to the data source
dotConnect for SQLite Standard Edition is a free of charge database connectivity solution built over ADO.NET architecture. It offers basic functionality for developing database-related applications, web sites.
dbForge Event Profiler for SQL Server is a free tool for capturing and analyzing SQL Server events. The events and data columns are stored in a physical trace file for later examination.
SDAC is a VCL/VCL.NET/CLX component library for fast direct access to SQL Server from Delphi and C++Builder. Supports all SQL Server data types and functionality, including MARS, bulk copy operations and reliable messaging.