dbForge Edge

Your ultimate multidatabase solution

If you are a database developer dealing with several projects, it means you have to handle a number of database management systems simultaneously. And for each of these systems, you need to have a proper set of tools at hand. Moreover, the said set of tools must be complete and flexible enough to follow the evolving project and its current requirements. At one point, you’re focused on designing databases, and then, in a while, your work evolves into routine querying and database maintenance. You need to have it all covered.

dbForge Edge is a perfect solution for full-stack database experts that helps them cover the broadest set of tasks across multiple database systems, including:

• Microsoft SQL Server

• MySQL

• Oracle Database

• PostgreSQL

• and more…

Database Design

• Design tables in a visual editor

  The built-in table designer comprises visual editors for columns, indexes, primary keys, foreign keys, check constraints, statistics, and table storage properties. You can edit table data, navigate through the visual editor and code editor simultaneously, use automatic prompts of data types, document tables, preview ALTER TABLE scripts, and rebuild your tables without affecting or losing the data contained within.

• Visualize database structures on ER diagrams

  You can create elaborate diagrams to visualize database structures and logical relations between tables. Moreover, you can edit database objects directly on these diagrams, group logically related objects using containers, and print out large database diagrams with ease.

Database Development

• Write SQL faster with the integrated coding assistance

  Level up the speed and quality of your daily SQL coding with context-aware keyword and object suggestions, phrase completion, instant syntax validation, versatile formatting, and refactoring with automatic correction of references to renamed objects.

• Debug stored procedures, triggers, and functions

  Get the easiest way of debugging your stored procedures, triggers, and functions by observing the runtime behavior of your database objects and locating logic errors. The integrated set of features that will help you do it includes step-by-step execution, call stack browsing, breakpoints and watches.

• Compare and deploy changes in your databases to different environments

  Keep your databases in sync by running fast comparisons of database schemas and table data, identifying and managing differences, and deploying them to the required target databases via autogenerated synchronization scripts.

• Link your databases to version control systems

  Version-control your schemas and static table data using the VCS of your choice (supported systems include Git, SVN, TFVC, Azure DevOps, Perforce, SourceGear Vault, Plastic SCM, and Mercurial). Work on a central database or your own local copy, commit and revert changes with dependency awareness, view and resolve conflicts, and track changes in the easiest way possible.

• Generate full database documentation

  Eliminate tedious and time-consuming manual documenting by autogenerating complete and relevant documentation for your databases in HTML, PDF, and Markdown formats.

Testing

• Generate meaningful test data

  Generate any volume of dummy data for testing with a wide array of predefined generators. Their flexible configuration options allow emulating column-intelligent, realistic data.

• Configure and automate database unit testing

  Develop stable and reliable code that can be regression-tested at the unit level. Run unit tests as part of your automated builds.

• Optimize your queries via profiling

  Use the integrated Query Profiler to visualize query execution plans, detect bottlenecks in query performance, compare differences in query profiling results, and optimize slow queries.

Data Management

• View and edit data in a visual data editor

  Management of table data has never been easier, allowing you to edit, filter, sort, and copy selected cells the way you need. You can also use quick data export to INSERT queries and view the said data in text, grid, or card view.

• Compare and synchronize table data

  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 from the command line.

• Import and export data in a variety of formats

  Migrate your data to and from 10+ most widely used data formats. Customize and manage the entire process. Create custom templates for recurring tasks and specify the error handling behavior.

Data Analysis

• Design complex queries visually

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

• Observe related data in Master-Detail Browser

  Use the integrated Master-Detail Browser to view and analyze data of tables linked together with foreign keys or user-defined interrelations by specifying the parent table, which gets data from its child tables in the same window.

• Aggregate data in visual pivot tables

  Pivot tables help you summarize and analyze data, which is placed on a chart that facilitates reporting and explores trends based on your information. It is useful for long rows or columns that hold values that you need to track the sums of and then easily compare.

• Generate data reports

  Create well-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.