dbForge: Your Trusty Set of Database Management and Development Tools

Database Design

Table designer contains visual editors for columns, indexes, primary keys, foreign keys, check constraints, statistics, and table storage properties. It allows you to edit table data, navigate through the visual editor and T-SQL editor synchronously, use automatic prompts of data types, document tables, preview ALTER TABLE scripts, and rebuild your table without losing its data.

Draw database structures on entity-relationship diagrams
Create a database diagram to visualize its structure and logical relations between tables. Edit database objects directly on the diagram. Cluster logically related objects using containers. Print out large database diagrams with convenience.

IMPLEMENTATION

Speed up SQL coding with context-based smart suggestions, perform scripts formatting and refactoring, improve code readability, and boost your overall productivity.

Stored routines debugging
Hunt down bugs in your code of stored procedures, triggers, and functions by observing their behavior at runtime using step-by-step execution, call stack browsing, breakpoints and watches.

Compare and deploy schema changes on different environments
Sync developers working in different teams with our comparison tools. Move database schema changes safely from a sandbox to a production server and upgrade the structure of databases.

Commit SQL objects to a source control repository
Version-control schemas and reference data in source control systems, such as SVN, TFS, and Git. Work on a central database or your own local copy, resolve conflicts, and roll back changes. Easily check who made the changes, when they made them, and why.

Database documentation
Create documents in HTML, PDF, or Markdown. Eliminate tedious and time-consuming manual documentation tasks. Keep teams up to date and satisfy audit requirements by maintaining and distributing complete and relevant documentation.

DATA LOADING

Enjoy managing tabular data: editing, filtering, sorting, and copying custom-selected cells. Use quick data export to the INSERT query and view it in text, grid, or card view.

Data comparison and synchronization
Copy lookup data from development databases to staging or production. Analyze data changes step by step by viewing different records, as well as new and missing ones. Automate comparison and synchronization tasks using command-line interface.

Import and export data to various file formats
Easily migrate your data to and from 10+ most widely used data formats. Customize and manage the entire process. Create templates for the scheduled process, specify error processing options, and log the process to a file.

Design complex queries visually

Draw queries of any complexity visually, without typing any code. Visualize designed queries on a diagram, work with subqueries, edit JOIN and WHERE conditions visually. Design INSERT, UPDATE, and DELETE queries in addition to SELECT queries.

Generate data reports
Make formatted representations of SQL data in PDF, DOCX and other file formats. Illustrate data as charts using a chart designer. Include aggregated data in the form of a pivot table. Display data from a hierarchical data source as a master-detail report.

Master-detail data browsing
View and analyze data of tables linked together with foreign keys or user-defined interrelations by setting up the parent table, which gets data from its child tables in the same window.

Aggregate data in a visual pivot table
Pivot table helps you analyze summarized data, which is placed on a chart that facilitates reporting and explores trends based on your information. It's useful for long rows or columns that hold values that you need to track the sums of and then easily compare.

MAINTENANCE

Monitor server performance in real time. In addition to disk loading metrics, CPU and memory usage metrics are displayed.

Manage index fragmentation
Analyze the status of table indexes and fix issues with index fragmentation. Collect fragmentation stats and detect databases that require maintenance. Instantly rebuild and reorganize indexes in a visual mode or generate scripts for future use.

Monitor server events
Based on SQL Server Extended Events, this tool helps you track and monitor instances using traces. Now you can easily locate and eliminate server performance bottlenecks.

Encrypt and decrypt routines
Encrypt and decrypt stored procedures, views, triggers, and functions in a responsive UI with syntax highlighting, Unicode support, batch mode, and decryption caching features.

Audit data changes and recover deleted records
View and analyze database transaction logs, see detailed information about all changes in the examined database, and recover data by reverting unwanted transactions on different levels.

Enhanced ADO.NET data providers take over the task of communicating with databases. They come with additional classes and innovative built-in tools for developing websites and applications that connect to databases and cloud services. dotConnect supports the latest versions of EF and EF Сore, SSIS components, and has its own ORM.
Learn More 

Devart ODBC Drivers are high-performance and feature-rich connectivity solutions for ODBC-compliant applications to access the most popular databases directly from Windows, macOS, and Linux, both 32-bit and 64-bit. Verified compatibility with multiple business intelligence, database management, and application development tools.
Learn More 

Devart SSIS Data Flow Components product line offers fast and reliable Source, Destination, and Lookup components for popular cloud applications and databases for creating SQL Server Integration Services packages. Develop high-performance flexible SSIS-based ETL solutions with Devart SSIS Data Flow Components.
Learn More 

With Devart Excel Add-ins you can get exactly the data you need with visual Query Builder or with SQL and refresh the queried external data in a workbook any time with a single click. External data can be edited as you usually do it in Excel, and then saved back to the data source.
Learn More 

Data Access Components is a data access library for developing multi-platform applications in Embarcadero RAD Studio, Delphi, C++Builder, Lazarus (and FPC) for Windows, macOS, Linux, iOS, and Android, both 32-bit and 64-bit platforms. The library supports various database systems and cloud services.
Learn More 

dbExpress is a database-independent layer that defines a common interface accessing database servers from Delphi and C++Builder on Windows and macOS, both 32-bit and 64-bit. dbExpress provides a driver as an independent library that implements the common dbExpress interface for processing queries and stored procedures.
Learn More 

                                                         Productivity tools

Code Review Bundle

Review Assistant

Code Compare

A popular comparison tool for file and folder comparison and merging, Code Compare takes into account specifics of programming languages (C#, Visual Basic, XML, XAML, etc.), supports two- and three- way comparison and merge. Code Compare comes as a stand-alone application or can be integrated into Visual Studio. Free version available!

T4 Editor

An advanced tool for Visual Studio that includes intelliSense-like, syntax highlighting, code outlining and other features of a text editor add-in for Visual Studio. T4 editor boosts performance, as well as speeds and simplifies the process of creating and editing T4 templates.
Learn More 

TMetric

TMetric is a time tracking web application for IT-professionals and companies. The tool will help individuals and organizations to be more productive. TMetric provides time tracking, work session monitoring, reporting tools, integrations and much more.

SecureBridge

SecureBridge is a library of Delphi and C++Builder components for Windows and Mac OS designed to protect connections between computers and trusted networks against unauthorized access.

dbMonitor

To extend monitoring capabilities of our data access products there is an additional tool called dbMonitor. It is an easy-to-use tool to provide visual monitoring of your database applications. dbMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute, creating and destroying components, connection pooling events etc.