User:On3oleg/sandbox

dbForge Edge

Original author(s)	Devart
Developer(s)	Devart
Initial release	2023
Stable release	1.3.5 / 2023-09-14
Operating system	Cross-platform
Available in	Multilingual
Type	SQL database management and development system
License	Proprietary / Shareware

dbForge Edge is a comprehensive database management suite developed by Devart. It offers integrated development environments (IDEs) for multiple database systems including SQL Server, MySQL, Oracle, and PostgreSQL. The platform provides a wide array of features for database design, development, testing, data management, and analysis. It aims to serve full-stack database experts and offers both a visual data editor and SQL coding assistance. The GUI tools is designed for versatility and aims to streamline various database-related tasks.

History

Devart, a software company founded in 1997, specializes in database management software and ALM solutions. The company has a global reach, serving developers in 120 countries. Among its products, dbForge Edge was initially released on March 24, 2023, and received an update on September 14, 2023.

Products included

dbForge Edge is a bundle of four sophisticated database IDEs, each offering distinct features that make it highly valuable for users with diverse needs.

dbForge Studio for SQL Server

dbForge Studio for SQL Server offers an all-in-one solution for SQL Server database development, management, and administration. It features capabilities like SQL code writing, database design, data synchronization, and DevOps automation. The platform also provides specialized tools for data reports and analysis. It is available on Windows, macOS, and Linux, aiming to enhance productivity and efficiency in database-related tasks.

Features

• Database Development
  • Edit and run queries in a new SQL document
  • Build queries in a visual designer
  • Run a large script without loading it into memory
  • Create unit tests using tSQLt framework
  • Debug stored procedures and functions
  • Source-control database changes
  • Create database objects in a visual editor
  • Generate database scripts
• Database Management
  • Compare and synchronize database schemas
  • Compare and synchronize data of two databases
  • Copy databases
  • Generate docs in HTML, PDF, or Markdown formats
  • Create schema snapshots
  • Generate test data and instantly populate a database
  • Export/import table data to a file (CSV, Excel, XML, etc.)
• Database Administration
  • Set up user accounts and permissions
  • Copy, move or upgrade a SQL Server database
  • Back up and restore databases
  • Monitor SQL Server performance in online mode
  • Generate schema and database scripts
  • Diagnose server problems using traces
  • Find and fix database index fragmentation issues
• Data Reports and Analysis
  • SQL Server Reporting
  • Pivot Tables
  • Data Compare
  • Master-Detail Browser

dbForge Studio for MySQL

dbForge Studio for MySQL is a universal integrated development environment (IDE) developed for MySQL and MariaDB database management. The software facilitates various tasks including query development, database design, and administration. It offers features such as SQL code completion, syntax checking, and database schema comparison. The platform aims to be an alternative to MySQL Workbench, providing a broader set of features for database development and management.

Features

• Database Development
  • MySQL code completion
  • SQL code formatting
  • Instant syntax check
  • MySQL Debugger
  • Query Profiler
  • MySQL Code Editor
• Database Design
  • Visual query builder
  • Database project framework
  • Table designer
• Database Management
  • Schema comparison and synchronization
  • Table data comparison and synchronization
  • Database duplication for migration to different servers
  • Generation of documentation in multiple formats
  • Test data generation
  • Export/import of table data
  • Backup and restore tools
• Database Administration
  • Session Manager
  • Data export and import
  • MySQL user management (Security Manager)
  • Duplication of databases for migration to different servers
  • Table data analysis tools
• Data Reporting and Analysis
  • Data Report Wizard
  • MySQL report designer
  • Pivot tables
  • Chart designer
  • Command-line support

dbForge Studio for Oracle

dbForge Studio for Oracle is designed to accelerate PL/SQL coding and offers a range of data editing tools. It features functionalities like IntelliSense-like PL/SQL code completion, query profiling, and data synchronization between different Oracle servers. The IDE is also equipped with visual tools for database design and schema management, making it a comprehensive solution for Oracle database development and administration.

Features

• Database Development
  • IntelliSense-like PL/SQL code completion
  • PL/SQL formatter
  • Query Profiler
  • Code snippets
  • PL/SQL debugger
  • Oracle PL/SQL performance tuning
• Database Design
  • Visual query builder
  • Visual database designer
  • Database diagrams
  • Visual editors for schema objects
  • Table designer
  • Database projects
• Database Management
  • Data import and data export
  • Schema export and import (dump)
  • Data comparison and synchronization
  • Schema comparison and synchronization
• Data Reporting and Analysis
  • Data report designer
  • Pivot tables
  • Automated data report delivery
  • Object search

dbForge Studio for PostgreSQL

dbForge Studio for PostgreSQL is an IDE which developed for PostgreSQL database development and management, offering features like SQL code completion, data import/export, and query profiling. It supports multiple operating systems including Windows, Linux, and macOS. The IDE aims to streamline database tasks, from query development to data reporting, and is compatible with various PostgreSQL versions.

Features

• Database Development
  • PostgreSQL code completion
  • SQL code formatting
  • Instant syntax check
  • Query Profiler
• Database Management
  • Schema comparison and synchronization
  • Table data comparison and synchronization
  • Test data generation
  • Export/import of table data
• Testing
  • Test data generation
  • Query profiling
• Data Reporting and Analysis
  • Data Report Wizard
  • PostgreSQL report designer
  • Pivot tables
  • Chart designer
  • Data Editor
  • Master-detail browser

Supported platforms and languages

dbForge Edge is primarily designed as a Windows application but also is compatible with macOS and Linux operating systems through the use of either Wine or CrossOver.

Available languages is English.

References

Category:Database administration tools Category:Data modeling tools Category:Microsoft database software Category:MySQL Category:MariaDB Category:PostgreSQL Category:Oracle database tools Category:PL/SQL_editors