DbForge Edge

From PostgreSQL wiki
Jump to navigationJump to search

dbForge Edge is a multidatabase solution for DB development, design, management, and administration. A set of powerful features applies to all the most popular database management systems – PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, and a wide range of cloud services.


This solution allows performing all database-related operations with professional tools for SQL coding, data management, database schema and data comparison and synchronization, test data generation, data analysis, reporting, and other tasks. The intuitive GUI helps perform a number of tasks visually, without excessive coding, which helps reduce the risk of error. Support for CLI allows automating most of the operations.


dbForge Edge meets the needs of a wide range of professionals who deal with databases, including full-stack specialists, database developers, administrators, data analysts, software architects, and anyone involved in database design, management, or optimization, regardless of their level of expertise.


Key features of dbForge Edge (note that the actual functionality may vary depending on the database system):


SQL coding assistance

  • SQL editor with numerous features that give a productivity boost to daily coding
  • Code autocompletion, syntax check, and code formatting
  • Custom code snippets (including a library of predefined snippets)


SQL query analysis and optimization

  • Query Plan in a graphical tree format
  • Query execution diagram with the cost breakdown
  • Top operations list showing the most expensive operations
  • Visual comparison of query profiling results


Comparison and synchronization of database schemas and data

  • Identification of differences in database schemas and table data
  • Analysis and management of differences
  • Synchronization of databases in manual or automated modes
  • Generation of synchronization scripts
  • Deployment of changes onto database servers (including supported cloud servers)
  • Automation of deployment routines through CLI


Management and analysis of database objects and table data

  • 10+ popular data formats for import and export
  • Backup and recovery of databases
  • Quick object location and object properties
  • Master-Detail Browser (viewing and analysis of related objects)
  • Data Editor to view, process, and analyze PostgreSQL data


Test data generation

  • Support for multiple data types
  • Generation of data in any volumes
  • 200+ predefined data generators
  • Templates for data generation tasks
  • CLI-based task automation


Data visualization and reporting

  • Pivot Tables for enhanced data analysis
  • Data Report Designer for static reports
  • Numerous customization options
  • Chart Designer for data dependencies
  • Exporting reports into several popular formats


Session and user management

  • Visual management of server sessions
  • Monitoring of events on the server
  • Creation, configuration, and editing of user accounts
  • Granting and revocation of user privileges
  • Management of SSL connections for user accounts


DevOps automation

  • Connection to version control systems
  • Automated database migration and deployment
  • Implementation of CI/CD pipelines
  • Unit tests in plain SQL


System requirements:

Microsoft Windows 7/8/8.1/10/11

Windows Server 2008/2012/2016/2019/2022


Compatibility:

Microsoft Windows: 7/8/8.1/10/11

Linux: Ubuntu/Fedora/Debian/Red Hat Enterprise Linux - available via CodeWeavers CrossOver

macOS: Monterey (version 12.00)/Big Sur (version 11.00)/Catalina (version 10.15)/Mojave (version 10.14)/High Sierra (version 10.13) - available via CodeWeavers CrossOver


Supported databases:

PostgreSQL 8.4-18

MySQL 5.5-8.3, MySQL 9.0 connectivity support

MariaDB 5.5-11.4

Percona 5.5-8.1

SQL Server 2000-2022, LocalDB, SQL Server installed on Linux

Oracle 8i, 9i, 10g, 11g, 12c, 18c, 19c, 21c, and 23c


Supported services:

StrongDM


Also, the solution supports all major database servers and cloud platforms related to PostgreSQL, SQL Server, MySQL, MariaDB, and Oracle, including:

Galera Cluster, Greenplum DB, Fujitsu Enterprise Postgres, HeatWave MySQL, SQL Azure, Amazon RDS, Amazon Aurora, Amazon Redshift, Google Cloud, Oracle Cloud, Alibaba Cloud, Tencent Cloud, Heroku, Aiven Cloud, SkySQL, YugabyteDB, PolarDB, Neon.tech, Citus Data, Bit.io, ApsaraDB RDS, AnalyticDB, EDB BigAnimal, ElephantSQL, IBM Cloud for PostgreSQL, Kamatera Performance Cloud, DigitalOcean Managed Database, Babelfish for Aurora PostgreSQL, Cloud Native PostgreSQL, TimescaleDB, Supabase, AlloyDB, and Azure Cosmos DB for PostgreSQL Cluster.


Learn more

dbForge Edge comes with a free 30-day trial.

Detailed information about the dbForge Edge functionality is provided on the official page.

Retrieved from "https://wiki.postgresql.org/index.php?title=DbForge_Edge&oldid=41533"