Skip to content
This repository was archived by the owner on Aug 3, 2024. It is now read-only.

SkinTalkPH/HTMLSchemaReport

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

How to: Import the HTML Schema Report plugin on MySQL Workbench 8.x.x CE

Posted by Lance Delariarte on September 20, 2022; 6:55 p.m.

Prerequisites

  • It's assumed that you downloaded the .msi installer and installed in your machine. If not, download here.
  • It's assumed that you have your .sql file with you, ready to import on Workbench.

Part (1/2): Import an SQL script

Step 1

Open the MySQL Workbench application. In my case, I have MySQL Workbench 8.0 CE installed on my machine.

image

Step 2

Click File > New Model or press Ctrl + N to create a New Model.

image

Step 3

A MySQL Model tab should be opened. Click File > Import > Reverse Engineer Create Script....

image

Step 4

On the Reverse Engineer SQL Script Screen, press the meatballs or ... menu to select an SQL script file.

Press the Execute button to continue.

image

Step 5

One the impost is finished, Reverse Engineer SQL script and Verify Results should be checked. Click Next to continue.

image

Step 6

Click Finish.

image

Part (2/2): Install the plugin

Step 1

Click Scripting > Install Plugin/Module....

image

Step 2

Locate the HTMLSchemaReport-WMB8.py file, select it.

image

Step 3

Click OK button and restart MySQL Workbench.

image

Step 4

Click the SQL that you imported. You may delete the mydb to avoid confusion.

image

Step 5

Click Tools > Catalog > HTML Format database schema report

image

Step 6

Create a name for your file, and click Save to continue.

image

Step 7

Open the HTML file that you generated.

image

About

A Python script plugin for MySQL Workbench 8.x CE to generate Data Dictionaries.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages