dbForge Studio for MySQL Screenshots

Each window of dbForge Studio for MySQL is designed to streamline your everyday tasks, ensure quality, and improve the final results. Administer and develop databases like a professional with professional dbForge Studio for MySQL!

• 
  Click to enlarge

  General View

  
  

  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.

• 
  Click to enlarge

  SQL Editing Tools

  
  

  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.

• 
  Click to enlarge

  Database Designer

  
  

  You can observe all objects of your database, see foreign key relations between tables, view database objects information, easily access database objects for editing, retrieving data, executing stored routines. With Database Designer you also can perform reverse engineering of your databases to IDEF1X or IE diagrams, which can be easily printed.

• 
  Click to enlarge

  Security Manager

  
  

  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.

• 
  Click to enlarge

  Stored Routine Debugger

  
  

  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.

• 
  Click to enlarge

  Schema Object Search

  
  

  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.

• 
  Click to enlarge

  Schema Comparison and Synchronization Tool

  
  

  You can compare and synchronize 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.

• 
  Click to enlarge

  Data Comparison and Synchronization Tool

  
  

  You can perform either complete or partial data comparing and synchronization. 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.

• 
  Click to enlarge

  Query Builder

  
  

  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.

• 
  Click to enlarge

  Database Project

  
  

  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.

• 
  Click to enlarge

  Schema Object Renaming

  
  

  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.