work bench

Do paper

MYSQL WORKBENCH
MANUEL SUBREDU
MSD - I

ABOUT
• Free unified of the eye tool
• Target:
• database architects
• developers
• DBA’s (DataBase Admins)

• Provides:
• Data modeling
• SQL unravelling
• Administration tools

• Cross platform:
• Windows
• MacOSX
• Linux

VISUAL SCHEMA DESIGN
• Main characteristics:

• Uses Model Driven Database Design
• Model and Schema Validation (commercial version only) • Uses all MySQL particular features, including advanced ones like: partitioning, InnoDB, Views, stored SQL Procedures.

• Forward engineering
• existing fashion into:
• physical database
• SQL scripts

• generated SQL scripts risk on the server at runtime

• Reverse engineering
• Sources:

• existing databases
• SQL scripts

VISUAL SCHEMA DESIGN - CONT
• Change Management
• database schema versioning
• schema syncronization and comparison usefulness
• synchronization (with conflict management) between a
facsimile and a live database – both ways
• simile between:
• two live databases
• model and a live database

• Visualisal representation of differences

• Documentation
• harvested land table/row can have it’s allow documentation
• flexible report generation based up~ all model data

VISUAL SCHEMA DESIGN SCREENSHOTS

VISUAL SCHEMA DESIGN SCREENSHOTS

VISUAL SCHEMA DESIGN SCREENSHOTS

VISUAL SCHEMA DESIGN SCREENSHOTS

SQL DEVELOPMENT
• Integrated Visual SQL Editor
syntax highlight
EXPLAIN ~er
Parallel execution of multiple SQL queries
Easy revise and correct of the data using standard grid format
Data be able to be exported into several formats (CSV, HTML, XML,
SQL INSERT)
• Complex narration support
• Most used SQL Selects, DML and DDL digest can be saved/ grouped into snippets.
•
•
•
•
•

SQL DEVELOPMENT - SCREENSHOTS

SQL DEVELOPMENT - SCREENSHOTS

SQL DEVELOPMENT - SCREENSHOTS

SERVER ADMINISTRATION
• User direction (privileges, passwords, access
lists)
•...

MANUEL SUBREDU

MSD - I

MYSQL WORKBENCH

Continues in the place of 14 more pages »

Read well stocked document

Full access is free because contributing users.

Add to Library  (0) Hide

Make trial