Each window of dbForge Studio for MySQL is designed to streamline your everyday tasks, ensure quality, and improve the final results. Develop and administer databases like a professional with professional dbForge Studio for MySQL!
Database Explorer gives a direct access to schema objects and their properties. Project Explorer simplifies your work with a database project. Tabbed documents provide a convenient interface for creating tables, managing data, and editing code. Dockable tool windows, toolbars, and a working area, which can be resized, give adjustable layout.
The Code Templates window has a set of frequently used code templates which you can insert in your code, rename or extend. Syntax check underlines all errors and shows error type and location in the error list. Code completion feature speeds up typing. The Find and Replace window provides a list of regular expressions to create a required search string. Bookmarks simplify code navigation. You can outline code blocks and create named regions. For easy work with code, you can hide or collapse code blocks.
You can set privileges for the users both on global and database levels. The General tab contains a name, a host, and other general parameters of user accounts. The SSL tab is for SSL-related parameters. The System tab allows you to set system privileges. The Object tab allows you to set privileges for the selected objects. The grid shows the whole list of privileges related to the user account.
Breakpoints stop execution on any code line. The Watches window allows evaluating of variables and parameters declared in the routine. The Call Stack window shows the stack of currently active stored routine calls.
The Find Object window allows you to search objects based on their name, text, or data. The Find Object Results window shows detailed information about each found match. Based on your needs, you can edit matches, clear all at once or navigate to a required one.
You can compare either two schemas or a schema and a project. The grid shows schema objects' names and types, comparison state and synchronization actions. Schema and connection of a source and a target are displayed above the grid. You can filter comparison results by state or group them by state and type.
You can perform either complete or partial data comparing. The grid shows compared tables and views. The results information includes the number of rows which are identical, different, located only in target or in source. You can filter the results. Schema and connection of source and target are displayed above the grid.
The diagram allows you to create a select statement of any complexity visually. The tables are added to the query via drag-and-drop from Database Explorer. You can switch to Text view to see and edit the query code. The tabs under the diagram allow managing the corresponding clauses of the select statement. The Where tab assists in creating complex conditions. They are shown as a tree with a condition and group nodes.
The Project Explorer window organizes all project items. The Object View window gives quick access to schema objects generated by project scripts. The project can be built to a single script file or several ones and easily deployed on the server.
You can rename various database objects. After renaming all references are automatically updated. The Preview Changes window shows all project changes. You can manually choose which changes to apply.
