Generating MySQL Database Documentation for Confluence with MySQL Workbench Plugin
来源:互联网 发布:知行教育 编辑:程序博客网 时间:2024/06/07 08:00
The MySQL Workbench can nicely generate a Entity Relationship model from your existing MySQL Database. After Installing click in the column labelled “Data Modelling” on the link below to “Create EER model from existing database”. Follow the wizard to have a generated diagram including your existing tables and their related information. Don’t forget to save the new ER model as *.mwb file.
For Documentation in a project is Confluence as Wiki very good compared to other ones like MediaWiki.
I have written a small plugin to MySQL Workbench as Lua Script to generate Database Model Documentation as Confluence Markup. If you are interested lookherefor Documentation about the available classes to use in your own scripts.
Part of the generated output from the sample database world from MySQL shown as result in Confluence:
Howto:
- Download this Script
- Start your MySQL Workbench
- Choose from the “scripting” menu the entry “Install Plugin/Module…”
- Change Drop down in the Dialog to File type ”lua Files..”
- Choose downloaded File and click open
- Restart Workbench
- Open previously generated ER model file *.mwb
- Choose from the “Plugins” menu the entry “Catalog” and their the new entry “Confluence Markup Exporter…”
- Markup is now in the clipboard
- Open in Confluence an existing page or create a new onw
- Click on “Edit” button and go to tab “Wiki Markup”
- Paste the generated documentation and click on “save” button
- Generating MySQL Database Documentation for Confluence with MySQL Workbench Plugin
- Mysql workbench
- MySQL WORKBENCH
- mysql workbench
- MySQL Workbench
- MySQL WorkBench
- MySQL Workbench
- mysql workbench中 Use database 报错 1049
- MySQL Workbench 报错 Cannot connect to Database Server
- database connection pool for mysql
- MySQL数据库、Navicat for MySQL、Workbench的安装
- MySQL(3)-MySQL Workbench
- Mysql及Mysql workbench
- 远程连接Hostinger MySQL数据库 setup remote MySQL Workbench connection to Hostinger MySQL database
- JIRA + MySQL + Confluence 安装
- Using a MySQL Database with C++
- Querying a MySQL database with LoadRunner
- Connection to MySQL Database with Java
- ioremap 与 mmap
- AS中实现利用队列将资源逐个进行加载
- 内存泄漏定位
- c/c++笔试题
- undefined reference to `__android_log_print'
- Generating MySQL Database Documentation for Confluence with MySQL Workbench Plugin
- ActivityGroup简介
- 10个iPhone开发网站、论坛、博客
- 【Android】对话框 AlertDialog
- 基础备忘:多态概念
- 关于gfortran以及ifort安装的若干问题
- java Servlet(1)
- C#random()函数
- struts2采用convention-plugin实现零配置