Dbforge Review

[Jenifer Griffard]

dbForgeStudio for MySQL has received praise from users and reviewers for its wide range of use cases and valuable features. Users have found it to be an essential tool for interacting with MariaDB and MySQL databases, particularly in comparing data between databases or tables. The software's ability to import and export data in various formats, such as CSV, Excel, and Word, has been commended for its convenience in working with different file types. Additionally, the database tools in dbForge Studio for MySQL have been highly appreciated for their session and security checks, enabling users to effectively monitor and maintain their databases' integrity.

The SQL query completion and error analysis feature has proven to be a valuable asset for developers, enhancing productivity by providing real-time suggestions and identifying errors. The creation of views and other objects with visuals and wizards simplifies the process of creating and modifying stored procedures. Users have praised dbForge Studio for MySQL's reporting and visualization capabilities, although some have not fully explored these features yet.

Furthermore, the software has been instrumental in facilitating database version upgrades and platform migrations, ensuring smooth transitions between database versions and platforms. Its code completion and suggestion functionalities have garnered commendation for their accuracy and effectiveness in expediting IT staff's database tasks. Notably, during an Oracle Utilities Suite upgrade implementation, users have found the tool crucial in identifying DDL, index, partitioning, PK, and constraint errors, allowing them to promptly address discrepancies.

In various industries like transport management software development and agriculture, dbForge Studio for MySQL has played a significant role in improving productivity through features like code completion, easy debugging, database design capabilities, query writing, generating meaningful test data, and more. The software has proven valuable across organizations in optimizing workflows and addressing database administration challenges.

For specific use cases like updating parts prices in a MySQL database for a company dealing with vintage Mustangs and selling parts, dbForge Studio for MySQL stands out with its user-friendly interface and efficient functionality. The ability to take backups of the entire database and restore them as needed has been widely appreciated by users.

Additionally, dbForge Studio for SQL Server has been lauded for its user-friendly experience compared to SQL Management Studio, empowering users to be more productive in SQL Server management and development tasks. Its features, including database documentation, schema and data comparison, unit testing, code formatting, source control, database design, index management, data generation, search, monitoring, backup and restore, debugging, query profiling, and IntelliSense have been well-implemented and eliminating the need for additional tools and providing benefits in schema comparison and deployment, code completion, intelligent IntelliSense, and code suggestions. Likewise, dbForge Studio for PostgreSQL has gained recognition as a suitable replacement for SQL Management Studio, particularly for data querying and editing tasks. Its well-organized user interface and useful features like grouping and sorting data directly in the data grids have been appreciated by users.

The versatility of dbForge Studio for MySQL extends to its usage in syncing data between pre-production environments, troubleshooting differences in data, and generating update scripts for syncing other environments with the help of dbForge Data Compare for MySQL. Users have found this tool valuable in maintaining consistency across various stages of software development.

Technical support for dbForge Studio products has received commendations, with prompt bug fixes reported even before becoming customers. Additionally, the ability for users to publicly request new features that are implemented if voted on by other users demonstrates a responsive approach to meeting user needs.

Across different domains such as query management and editing, designing databases, writing SQL code, monitoring running SQLs, administrative tasks, and data management for HR departments, dbForge Studio products have proven to be reliable and efficient tools. Users appreciate the intuitive interfaces, SSH connection capability, gibberish data generator, and automation of repetitive tasks in dbForge Studio for SQL Server.

In summary, dbForge Studio products have been valued by users as critical tools for interacting with databases like MariaDB, MySQL, SQL Server, and Oracle. The software offers a wide range of features including data comparison and synchronization, code completion and analysis, visualization capabilities, version control support, backup and restore functionality, database design tools, as well as excellent technical support. It addresses various needs across industries such as software development, database administration, query management, and more.

Useful Import and Export Wizards: Many users have found the Import and Export wizards in the tool to be very useful, with a lot of options and a handy wizard. Several reviewers appreciate the ability to import data to tables that other import tools struggle with.

Effective Data Comparison Tools: The tool's ability to compare data between tables or databases is highly praised by users. It has been described as great for identifying discrepancies, inconsistencies, and changes between source and target environments. Some users also value the schema comparison tool, which is useful for upgrades or syncing up databases.

Intuitive Create View/Edit View Tool: Users find the create view/edit view tool intuitive and easy to use. They appreciate being able to drag and drop from any table, perform functions on any field, and visually see all joins, grouping, and other criteria. This feature doesn't compromise functionality while making the process easy for users.

Inconsistent SQL conversion: Some users have mentioned that the conversion from SQL to the visual tool in dbForge Studio is not always clean, leading to inconsistencies and errors in the view's logic.

Limited customization of output reports: Several users have expressed dissatisfaction with the plain and minimalistic output reports generated by dbForge Studio. They believe that these reports lack detail and structure, suggesting that they could be improved with more comprehensive information and a pivot table-like format.

Lack of database analytics windows: A number of users have pointed out the absence of database analytics windows in dbForge Studio. They feel that this hampers their ability to gather insights into currently running queries and obtain better statistics about their MySQL servers.

Iterative code review refers to the situation when a single piece of work is reviewed more than once by the same reviewer.

In fact this is a regular case. None of major changes in code will pass without reviewers comments. They find bugs and faults which an author should fix, and then show the code over again.

The Review Assistant documentation contains more detailed description of the iterative code review.

Not all code review tools support repetitive code inspections within a single review. Review Assistant has been providing this feature since the first release. In Review Assistant 2.0 we have significantly improved this process.

The most important innovation is that a reviewer can track the files they have already reviewed.

Previously a user had to keep this information in mind. If the list of files in a review is too long, it is easy to lose track of what has and what has not been reviewed.

As you can see in the picture, the review progress is defined by two characteristics:

It often happens that the author adds wrong revisions to a review, or frequently leaves out of account the correct ones. In the previous versions of Review Assistant it was impossible to correct this selection mistake after saving a review.

As we see, the report combines data from the project repository with the data on preformed reviews. The Status column shows whether the given revision was reviewed or not. Also, the Linked Reviews column allows to quickly navigate to the Code Review Board and view the details of a particular review.

By looking at Figure 1, it becomes obvious that not all revisions should be put into consideration when estimating the coverage of the review project. Even such small commit range includes two commits, that were automatically generated by Git source control. Therefore, to prepare data for analysis, we need to:

Now our report contains meaningful revisions. So, we can estimate how many revisions passed through code revision. In this regard, we need to group the report by the Status column. Right-click the header of the column and select Group By This Column from the popup menu (see Figure 3).

When it comes to the Code Coverage report, it is important to say, that we estimate the number of reviewed revisions, not code lines. Our estimation of the reviewed code volume is based on the presumption, that all revisions are approximately of the same size. Also, we presume that the project code is reviewed on a regular basis, not from time to time (in the latter case, there is no sense to estimate statistics at all).

Summary: This article will demonstrate how code review workflow in Visual Studio 2019 can be more efficient with Review Assistant. We will introduce you to some great capabilities of our code review tool.

The quality of code can be significantly improved by making code reviews. We will use a simple WPF application in Visual Studio 2019 as an example of how to conduct an effective team code review with Review Assistant.

A reviewer can see a newly-created review on the Code Review Board. He opens a review, checks a file or code, and if there is a defect, he can add a comment. Review Assistant allows you to add different types of comments. The color of comment balloons changes in order for users to visually track comment statuses.

3a8082e126