DBArtisan from Embarcadero Technologies (acquired by Idera) is a database administration toolset.
N/A
dbForge Studio (Edge)
Score 8.9 out of 10
N/A
dbForge Studio is provided by
Devart and is a universal front-end client for database
management, administration and development. Devart's GUI tool provides
utilities to compare, synchronize, and back up databases (e.g. MySQL, Oracle, SQL Server, PostgreSQL, etc.) with scheduling,
and includes the possibility to analyze and report MySQL tables data. For example, dbForge
Studio for MySQL works with any MariaDB database servers, and supports all
MariaDB objects types. This solution enables users…
This tool is useful for small and large IT departments and associated data analysts that perform direct database functions such as DBA tasks or extracting/importing data. Non-technical staff members would not benefit from this tool as much as the functions are detailed and technical. However, automation engineers will find this tool very open for automation, and can generate the scripting code for any of its functions.
User interface is easy to use, and in some ways better than Toad. The left hand side shows all databases, and you can drill down to instance, storage, schemas, tablespaces, and performance views. The right hand side displays the details of the selected object.
This is the best tool if you want to manage multiple RDBMS platforms in a single tool using the same familiar interface. Other third party tools can do it also, but it's not nearly as integrated as this, and may require additional plug-ins installed. DBArtisan excels at this, and can perform cross-platform data migrations easily.
It has different DB analysts, which can help diagnose issues with performance, optimize storage, detect fragmentation, and plan for capacity growth. For almost any action you want to take, you can generate the DDL for preview, and/or schedule it to run at a specific time.
The ability to parameterize searches more would be advantageous. For example, being able to specify to only look for certain columns, certain data type changes, etc.
The output reports from dbForge are very plain and could contain more detail, and perhaps be structured more like a pivot table form Excel
Although experience here is limited, as only one question has been asked and answered promptly, the registration and licensing process was very smooth and professional. There are forums online that discuss dbForge issues, as well as a Facts and Questions section on dbForge's website, so product support does seem to exist if needed.
Before choosing dbForge Studio I evaluated at least a dozen tools, especially on the Visual Query Builder function. For now, I have identified only one product that has a better Visual Query Builder than dbForge Studio. This other product also manages UNIONs, while dbStudio still doesn't do it visually. However, the better alternative product is enormously slower in operations and less feature-rich than DbForge Studio
It has a positive ROI on our organization. It's better than OEM and SQL Developer. Although the license could be expensive, it is perfect for large organizations, especially with multiple RDBMS platforms.
Most features are redundant between DBArtisan and Toad. I would not recommend using both if you already own one of them. Just download the trial for the one you're not using, and see what works best for your organization.
DBArtisan is great for DBAs and would be my personal preference. Toad is good for developers and DBAs alike but I feel like sometimes the interface is too busy and too clumsy to use.
