MySQL and MariaDB client for Windows with GUI environment

Learn more about dbForge Studio for MySQL - the best GUI tool for managing, developing and administrating MySQL and MariaDB databases. Read more: https://www.devart.com/dbforge/mysql/studio/

---

Closed Caption:

Welcome to dForge for MySQL Overview.
We will talk about dbForge Studio for MySQL
features.
MySQL Connectivity:
- MySQL, MariaDB, and Percona support
- Connection to Sphinx Search Engine
- Secure connections via SSL/SSH
- HTTP connections via PHP tunnel
- PAM authentication plugin and Windows
authentication
- Working with MySQL on Amazon RDS
Administration and Maintenance:
- Security Manager to manage users' privileges
- Session Manager to monitor server
connections status
- Service Control window to start and stop
MySQL servers
- Table Maintenance wizard for check, analysis,
repair, and optimization of tables
- Server Variables window and server objects
flush dialog
Data Analysis
- Master-detail data browser
- Data Report and Chart building wizards
- Pivot Table designer
- Live database objects search
- Command line support
Data Comparison and Synchronization
- Comparing and synchronizing data in
databases of any size
- Comparison of custom query results
- Generation of data synchronization script
- Comparison reports in HTML and Excel
formats
- Command line support
Data Editor
- Custom data filters of any complexity
- Data Viewer window for browsing big data
- Copying of any data block to clipboard
- Full-text and incremental search
- Report, chart, and pivot building directly from
data editor
Database Backup
- Backup and restore wizards
- Large database support
- Zip compression for backup files
- Command line support for scheduling backup
tasks
- Error and status logging
Database Explorer
- Multiple database connections
- Dependency tree for all objects
- Duplicate object feature
- Automatic DDL generation
- Possibility of filtering objects in the tree
Database Refactoring
- Renaming of tables, columns, views,
procedures, and functions
- Database changes preview
- Possibility of generating a database refactoring
script
- Objects refactoring from Database Explorer
Debugger
- Stored procedure, function, trigger, and script
debugging
- Step Into, Step Over, and Step Out commands
- Call Stack, Watches, and Breakpoints
windows
- Single-click debug engine deployment
MariaDB specific features
- Dynamic columns syntax for DML statements
- Multi-source replication syntax
- Aria storage engine support
- Virtual columns and microseconds support
Exporting and Importing Data
- Data export to 11 popular formats
- Export data from multiple tables at once
- Command line support
- Data import from 8 popular formats
- Templates for exporting and importing
Flat Table Editor
- Visual editors for columns, foreign keys,
primary keys, and indexes
- Partitioning support
- Editable column grid
- Full-text search on the column grid
Object Editors
- Visual editors for database, tables, columns,
indexes, and views
- Visual editors for triggers, events, and user-
defined functions
- Combined editors for stored procedures and
functions
- Ability to browse schema objects in a single
editor (pin document)
- Schema object search based on a variety of
parameters
Database Projects
- New project wizard with import from an existing
database
- Project Explorer and Schema View windows
- Multiple build configurations
- Code refactoring
Query Builder
- The state-of-art diagram with zoom and
keyboard support
- Document Outline window
- Visual sub-queries creation
- Visual expression editor to create complex
conditions
- Possibility of changing a query type in a split
second
Query Profiler
- SHOW PROFILE, EXPLAIN results and
STATUS variables displayed in UI
- Profiling history that can be saved for further
analysis
- Compare profiling results
- Profiling results printing
Schema Comparison
- Compare a live database and a project
- Comparison reports in HTML and Excel
formats
- Command line support
- Comparing databases of different server
versions
- Preview script changes
SQL Editing and Execution
- Automatic SQL syntax check
- Code Snippet Wizard
- Context-sensitive code completion
- Parameter information for stored routines
- Quick information about schema objects
Visual Database Designer
- Tables, views, and stored routines visualization
- Easy access to database objects
- Smart diagram layout
- Diagram Overview and Document Outline for
quick navigation
User Interface
- Start page provides an easy access to main
product features
- Restoring document tabs from the last session
- Visual Studio skins and Dark skins
- Rich customization options
- Wizard for exporting/importing user settings
Try all the aforesaid and many other features of dbForge Studio for
MySQL for free. Thank you for watching.