Database Design

Design tables in visual editor

Table designer contains visual editors for сolumns, indexes, primary keys, foreign keys, check constraints, statistics, table storage properties. Table designer 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 table without losing its data.

Draw objects in database diagram

Create a database diagram to visualize its structure and logical relations between tables, cluster logically related objects using containers, edit database objects directly on the diagram, and print out large SQL database diagrams.

Available in

Implementation

Coding assistance and refactoring

Speed up SQL code writing, by utilizing context-based smart suggestions, perform automatic formatting and refactoring, improve code readability, increase productivity, and lower costs.

T-SQL and stored routines debugging

Find errors in SQL scripts, stored procedures, triggers, and functions by observing their behavior at runtime using step-by-step execution, call stack browsing, breakpoints and watches. Evaluate variables and parameters declared in routines in the Watches window.

Compare database schemas on different instances

Move database schema from a sandbox to production or upgrade your databases when developers are working in different teams.

Database source versioning

Link your SQL database to popular source control systems, such as SVN, TFS, Git, Perforce, Mercurial, and SourceGear Vault, and manage database changes in a familiar environment.

Database documentation

Create comprehensive SQL Server database documentation in just a few clicks. A wide range of options lets you customize the look and feel of your documentation as suits you best.

Testing and performance tuning

Generate test data

Generate large volumes of meaningful test data. A great choice of predefined generators with sensible configuration options, that allow emulating column-intelligent real-world data.

Database unit testing

Develop a stable and reliable code that can be properly regression tested at the unit level.

Query profiling

Visualize query execution plan and tune query performance, locate bottlenecks and optimize slowly running queries.

Data Loading

Edit data in convenient visual editor

Enjoy managing tabular data: editing, filtering, sorting, copying randomly selected cells, quick data export to INSERT query and many other features for a better efficiency.

Compare and sync data on different servers

Synchronize databases on several environments, analyze changes on a step-by-step basis by viewing different records, new records, and missing ones, synchronize databases that don't have a permanent connection, and much more.

Data importing and exporting

Easily migrate SQL data to/from 10+ most widely-used data formats, customize and manage the whole process, create templates for recurring scenarios, specify error processing options as well as write reports to a log file.

Operation

Design complex queries visually

Quickly build queries of any complexity using only a mouse, visualize each query in a separate visual editor, work with subqueries, edit JOIN and WHERE conditions visually.

Data reporting

Create SQL data reports implemented in a user-friendly interface. The routine of SQL data analysis and report creating is simplified to several clicks — that means you won't have to spend a lot of time and efforts for SQL report producing anymore.

Master-Detail browsing

View and edit objects linked together with foreign keys or user-defined relationships.

Pivot data viewing

A pivot transformation is one way to transform data from a tall/skinny format to a short/wide format. The data is distributed into columns usually aggregating the values. This means that multiple values from the original data end up in the same place in the new data table.

Maintenance

Database monitoring

Easily track the system load and view SQL performance metrics. Analyze wait statistics and query execution plan helps you detect performance issues and make the troubleshooting process more efficient and easier.

Manage index fragmentation

Analyze the status of SQL indexes and fix issues with index fragmentation. Collect index fragmentation statistics and detect database that requires maintenance. You can instantly rebuild and reorganize SQL indexes in a visual mode or generate SQL script for future use.

Monitor server events

Based on SQL Server Extended Events, the tool allows to track and monitor instances using traces. Eliminate server performance bottlenecks and get rid of them.

Encrypting/decrypting routines

A great functionality for decrypting stored-procedures, views, triggers, and functions with a highly responsive UI, syntax highlighting, Unicode support, batch mode, and decryption caching.

Developer Bundle for SQL Server

A comprehensive solution that extends SSMS functionality. It includes all Devart tools for SQL Server and allows you to save a considerable amount of money if purchased in a pack.

Database Design

Design tables in visual editor

A Visual Designer for creating and modifying a table structure and indexes in a single visual grid. The tool has a handy feature that suggests a column type based on the name of a column being created.

Draw objects in database diagram

The easiest way to visualize your database structure, as well as create, analyze, reverse-engineer, print and customize your MySQL databases.

Database projecting

A collection of SQL scripts and query files logically organized in one place allowing to develop databases in an offline mode within a fully customizable environment. Database projects can be built to different outputs. An adjustable build order allows you to include only necessary files to the output in different configurations.

Available in

Implementation

Coding assistance and refactoring

Reduce the time you spend on typing SQL code with intelligent features such as phrase completion, formatting, code snippets and navigation, quick object info, and syntax check.

Stored routines debugging

Debugger for MySQL offers a step-by-step code execution, breakpoints, watches, a call stack, a variable evaluation mechanism to debug procedures, functions, and triggers.

Compare schema objects on different instances

Move database schema from a sandbox to production or upgrade your databases when developers are working in different teams.

Database documentation

Generate a comprehensive MySQL and MariaDB database documentation and customize it in your own way with the help of built-in style templates.

Testing and Performance Tuning

Generate test data

A set of 200+ generators to quickly populate a MySQL database with realistic test data. The tool supports all MySQL data types and a bunch of settings to customize data generation.

Query profiling

Detect problems and optimize multi-second queries, find bottlenecks and get SHOW PROFILE and EXPLAIN results graphically displayed in a convenient UI.

Data Loading

Edit data in convenient visual editor

An easy and convenient way to manage data: insert, delete, edit, filter, sort, copy randomly selected cells, and many other features for better efficiency.

Compare and sync data on different servers

A reliable data comparison and synchronization tool that allows to view and analyze comparison results, run automatic comparison and synchronization processes, generate data comparison reports.

Data importing and exporting

You can import and import data to/from 10+ most popular data formats with a multitude of options to customize data import and export.

Operation

Design complex queries visually

Build queries of any complexity, add tables, create JOINs, and edit conditions on a visual diagram using only a mouse. Effortlessly group, sort, and filter data in the grid of the MySQL query editor.

Data reporting

Create SQL data reports implemented in a user-friendly interface. The routine of SQL data analysis and report creating is simplified to several clicks — that means you won't have to spend a lot of time and efforts for SQL report producing anymore.

Master-Detail browsing

A handy way to view and analyze related data in parent tables or views, related child tables or views, and self-referencing tables.

Pivot data viewing

Rearrange data in a table until you get the best layout for understanding data relations and dependencies due to a wide choice of styles, different types of filtering and grouping, and various summary functions.

Maintenance

Security management

Effortlessly create, edit, or delete user accounts, grant or revoke privileges, and fully control database security in a clear graphical user interface.

Table maintenance

A handy feature to analyze tables, check tables for errors, optimize data files, and repair corrupted files.

Session monitoring

Easily track the system load and view SQL performance metrics. Analyze wait statistics and query execution plan helps you detect performance issues and make the troubleshooting process more efficient and easier.

Available in

Database Design

Design tables in visual editor

An elaborated Table Designer that allows to visually create and edit tables, columns, keys, indexes, relationships, and constraints without any code typing.

Draw objects in database diagram

Drag database objects from Database Explorer to the diagram tool. The diagram will reflect all objects and existing connections simplifying further analysis.

Database projecting

You get a quick access to SQL scripts and database objects logically organized in one place letting you develop databases in an offline mode within a fully customizable environment.

Available in

Implementation

Coding assistance and refactoring

Enjoy IntelliSense-like PL/SQL code completion, write and format code on the fly with column picker, quick info on schema objects, code snippets, code refactoring, and more.

PL/SQL debugging

Automate all time-consuming tasks related to debugging and get full code control over your coded, navigate inside the code, analyze call stack or view variable values

Compare schemas on different servers

Get a full picture of the differences between two schemas and set up sync process to achieve safe and accurate synchronization of database schemas without data loss.

Database documentation

This great tool with rich customization features automatically generates documentation of an entire Oracle database just in a few clicks.

Invalid object managing

This functionality allows to search your database schema for invalid objects, search for specific types of invalid objects, compile the selected ones, and export results.

Testing and Performance Tuning

Generate test data

A mighty GUI with an extensive collection of meaningful generators, flexible customization options for delivering flawless data generation.

Query profiling

Tune slow-running queries in the most effective way, start by identifying multi-second queries and then analyze them in a visual mode.

Data Loading

Edit data in convenient visual editor

A great functionality to effectively manage database data &ndash insert, delete, edit, filter, sort, and copy randomly selected cells.

Compare and sync data between tables

Quickly compare data in two or more tables, find the differences at a glance, and generate a script to effortlessly synchronize data.

Data importing and exporting

Easily export/import Oracle table data from/to most widely-used file formats. You can select specific columns and specify data formats for each field, and then save the defined export/import options for further usage.

Operation

Design complex queries visually

Visually design any queries and subqueries you need, build SELECT statements with multiple tables, joins, conditions, all this without manual typing of code.

Data reporting

Build various kinds of Oracle reports, pivot tables with parameters, customizable formatting, calculated summaries with help of a handy wizard that will guide you through every step of the report creation.

Master-Detail browsing

Viewing and analyze data in parent tables or views as well as in related child tables or views, and also in self-referencing tables.

Pivot data viewing

Become a data management guru, convert large amounts of data into compact and informative summaries - pivot tables. Rearrange data the way that best suits you With a few clicks of your mouse.

Available in

Maintenance

Security management

Provide the best security for your Oracle databases, create new user accounts, edit the existing ones, and delete them, grant and revoke privileges, manipulate roles, and profiles, while working with several accounts at a time.

Event monitoring

Oracle administrators will be able to send and receive alerts and pipe messages, as well as listen to alerts, get alerts and pipe messages, and send them.

Session monitoring

Retrieve full information about the current session or kill any query or session using a neat user interface, where you can find the grid with the list of current sessions, cursor list and SQL fragment of the selected cursorб and not just that.

Available in

Implementation

Coding assistance

Speed up SQL code writing, by utilizing context-based smart suggestions, perform automatic formatting and refactoring, improve code readability, increase productivity, and lower costs.

Available in

Data Loading

Edit data in convenient visual editor

Manipulate table data in different ways: edit, filter, sort, copy randomly selected cells, quickly export data to INSERT query and many other features for a better efficiency.

Compare and sync data on different servers

Compare separate tables or table groups by table name mask, identify the differences between two databases, analyze changes, sync data in tables and views in full or in part, and generate scripts for database synchronization.

Data importing and exporting

Fill a database with external source data and migrate data between systems, with a great number of advanced options, templates for recurring scenarios, customizable regular command-line import and export.

Operation

Data reporting

Convert your data into a good-looking report, build visual PostgreSQL data reports in 9 different formats. The command-line interface helps you to schedule automatic report delivery.

Master-Detail browsing

View in related tables, which is convenient for express data analysis, and locate specific records and logical errors in a database.

Pivot data viewing

You don't need to go into PostgreSQL subtleties to group and summarize your data. Make your data easier to read, understand, and analyze with advanced filtering and visual data presentation in a graph.

Available in