dbForge
{{unreliable sources|date=April 2025}}
File:DbForge_Studio_for_Oracle_ua.png
dbForge is a database management product line started in 2005. It focuses on database development, design, management, and administration for SQL Server, MySQL, MariaDB, Oracle, PostgreSQL database management systems, and a number of cloud services, data storage platforms, and search engines. dbForge services include separate tools for code completion, database documentation, database data and schema comparison, and tool bundles for specific databases. Additionally, dbForge products provide add-ins for Microsoft SSMS and Visual Studio.{{Cite web |last=Gribkov |first=Evgeniy |date=2020-09-29 |title=Best Database design tools for Forward and Reverse Engineering |url=https://towardsdatascience.com/best-database-design-tools-for-forward-and-reverse-engineering-cdaab971013d |access-date=2024-10-23 |website=Medium |language=en}}
History
The dbForge product line started with dbForge Studio for Oracle in May 2005.{{Cite web |title=DbForge Studio for Oracle Product Review - Oracle FAQ |url=https://www.orafaq.com/wiki/DbForge_Studio_for_Oracle_Product_Review |access-date=2024-10-23 |website=www.orafaq.com}} The product was previously known as OraDeveloper Studio and was rebranded to its current name in 2011.{{Cite web |title=Alternatives to Toad |url=https://stackoverflow.com/questions/214930/alternatives-to-toad |access-date=2024-10-23 |website=Stack Overflow |language=en}} The first features of dbForge Studio for Oracle covered database export and import, a DDL generation wizard, database object search, and dynamic data viewing in Database Explorer.{{Cite web |title=dbForge Studio for Oracle: completed (43 ideas) – Customer Feedback for Devart |url=https://devart.uservoice.com/forums/132897-dbforge-studio-for-oracle?filter=top&page=2&status_id=216369 |access-date=2024-10-23 |website=devart.uservoice.com}}
dbForge Studio for MySQL was released later in 2005.{{Cite book |last=Piñero Gomez |first=Jose Manuel |url=https://books.google.com/books?id=k-fxCAAAQBAJ&dq=dbForge&pg=PA87 |title=Desarrollo de programas en el entorno de la base de datos |date=2015-01-01 |publisher=Ediciones Paraninfo |isbn=978-84-283-9823-7 |language=es}} Its first versions featured database user privilege management, database export and import in different formats, script generation, and dynamic data viewing in Database Explorer.{{Cite web |last=Guess |first=A. R. |date=2018-06-26 |title=Devart: Support for MySQL v8.0 is Already in dbForge Studio |url=https://www.dataversity.net/devart-support-mysql-v8-0-already-dbforge-studio/ |access-date=2024-10-23 |website=Dataversity |language=en-US}}
In 2010, Devart introduced dbForge Data Studio for SQL Server, which provided database development and management functionality.{{Cite web |title=Купити Devart dbForge Studio for SQL Server ліцензію в інтернет-магазині Softkey.UA |url=https://www.softkey.ua/ua/catalog/programming/devart-dbforge-studio-for-sql-server/ |access-date=2024-10-23 |website=Softkey UA |language=uk}} Later, in 2011, this service became known as dbForge Studio for SQL Server,{{Cite web |title=dbForge Studio (Edge) Reviews & Ratings 2024 |url=https://www.trustradius.com/products/dbforge-studio/reviews |access-date=2024-10-23 |website=www.trustradius.com |language=en-US}}and later that year dbForge SQL Complete was launched as an add-in for context-aware code autocompletion and debugging in SSMS and Visual Studio.{{Cite web |title=Microsoft Azure Marketplace |url=https://azuremarketplace.microsoft.com/en-us/marketplace/apps/devartsro1663062248796.dbforgesqlcomplete_19062023?tab=overview |access-date=2024-10-23 |website=azuremarketplace.microsoft.com |language=en-us}}{{Cite book |last=Wright |first=Paul |url=https://books.google.com/books?id=5piJAwAAQBAJ&dq=dbForge&pg=PA37 |title=Protecting Oracle Database 12c |date=2014-04-19 |publisher=Apress |isbn=978-1-4302-6212-1 |language=en}} In 2012, dbForge SQL Tools (ex-dbForge Developer Bundle for SQL Server), a pack of 15 products that cover different tasks related to Microsoft SQL Server and Azure SQL Database, was launched.{{Cite web |title=About dbForge Compare Bundle for SQL Server |url=https://www.componentsource.com/product/dbforge-compare-bundle-for-sql-server/about |access-date=2024-10-23 |website=ComponentSource |language=en}}{{Cite journal |last=Карпенко |first=Роман |date=2012 |title=dbForge Studio: Комплексное решение для работы с базами данных |url=https://www.chipnews.com.ua/ |journal=Chip Україна |issue=9 |pages=84–86}} dbForge Studio for PostgreSQL was released in March 2018.{{Cite web |last=Frank |first=Charlie |date=2018-03-22 |title=Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDE for working with PostgreSQL databases |url=https://www.devx.com/upload/introducing-brand-new-dbforge-studio-for-postgresql-a-powerful-ide-for-working-with-postgresql-databases-180322041027/ |access-date=2024-10-23 |website=DevX |language=en-US}} This integrated development environment (IDE) provided multiple features for PostgreSQL data reporting, data editing, data import and export, as well as for building pivot tables and master-detail relations.{{Cite web |title=PostgreSQL: News Archive |url=https://www.postgresql.org/about/newsarchive/-/20180322/ |access-date=2024-10-23 |website=www.postgresql.org}}{{Cite journal |last=Олег |first=Гончар |date=2018 |title=Эффективные инструменты для работы с базами данных |url=https://hi-tech.ua/ |journal=Hi-Tech |issue=7 |pages=32–35}}
In 2023, dbForge Edge was launched as a suite of four IDEs for SQL Server, MySQL/MariaDB, Oracle, and PostgreSQL database management systems, and their cloud versions.{{Cite web |last=Stokeston |first=Devin |date=2023-05-30 |title=dbForge Edge Review 2023: Will this Save You from Mixed SQL Database Headaches? |url=https://www.opengeocode.org/2023/05/30/dbforge-edge-review-2023-will-this-save-you-from-mixed-sql-database-headaches/ |access-date=2024-10-23 |website=Structured Data |language=en-US}}{{Cite web |title=dbForge Edge |url=https://mariadb.com/kb/en/dbforge-edge/ |access-date=2024-10-23 |website=MariaDB KnowledgeBase}} In 2023, the product line secured 62 badges for high performance and ease of implementation, five awards from SoftwareSuggest,{{Cite web |title=G2 Summer Report 2024: Mirro Celebrates New Badges |url=https://mirro.io/blog/g2s-2024-summer-reports/ |access-date=2024-10-23 |website=mirro.io |language=en}} and recognition from DBTA as the Best Database Performance Solution of 2023.{{Cite web |date=2023-08-14 |title=Devart Leads in Two Categories at DBTA Readers' Choice Awards 2023 |url=https://www.mynewsdesk.com/ua/devart/pressreleases/devart-leads-in-two-categories-at-dbta-readers-choice-awards-2023-3267068 |access-date=2024-10-23 |website=Mynewsdesk |language=en}} By 2024, dbForge Studios had received 80 endorsements from G2 Crowd.{{Cite web |title=Easiest To Use Database Management Systems (DBMS) |url=https://www.g2.com/categories/database-management-systems-dbms?rank=9&tab=easiest_to_use#rank-9 |access-date=2024-10-23 |website=G2 |language=en-us}} The dbForge product line won the DBTA Best Database Development Solution 2024 nomination.{{Cite web |date=2024-08-13 |title=DBTA Readers' Choice Award Winners (2024) |url=https://www.dbta.com/Editorial/Trends-and-Applications/DBTA-Readers-Choice-Award-Winners-2024-165316.aspx |access-date=2024-10-23 |website=Database Trends and Applications |language=en-US}}
Features
dbForge provides tools for SQL development, including SQL coding, debugging, visual query building, query optimization, test data generation, and version control integration. Database design is facilitated through visual object editors and database diagrams. Data is managed via import/export tools and a user-friendly data editor. dbForge products also have integrated functionality for the comparison and synchronization, backup/recovery, and migration of database schemas and data. Database administration features include the management of sessions, user roles, and permissions. Data analysis and reporting features include interactive pivot tables and customizable data reports. Recurring tasks like backups and data synchronization can be automated from the command line.{{Cite web |title=dbForge Studio for MySQL: Top (477 ideas) – Customer Feedback for Devart |url=https://devart.uservoice.com/forums/77293-dbforge-studio-for-mysql |access-date=2024-10-23 |website=devart.uservoice.com}}{{Cite book |last1=Domdouzis |first1=Konstantinos |url=https://books.google.com/books?id=YZEvEAAAQBAJ&dq=dbForge+has+the+following+use+cases+and+capabilities:&pg=PA352 |title=Concise Guide to Databases: A Practical Introduction |last2=Lake |first2=Peter |last3=Crowther |first3=Paul |date=2021-05-20 |publisher=Springer Nature |isbn=978-3-030-42224-0 |language=en}}