DBDesigner is the tool that I used for MySQL database design, modeling and creation. I have used other tools but found DBDesigner being the simplest to use, at least for me.
DBDesigner is developed and optimized for the open source MySQL-Database to support MySQL users with a powerful and free available design tool.
Features list taken from the website.
- Available on Linux / MS Windows
- User Interfaced based on industry standard layouting software
- Design Mode / Query Mode
- Reverse engineering MySQL, Oracle, MSSQL and any ODBC databases
- User defined schema-generation
- Model-To-Database syncronisation
- Index support
- Automatic foreign key placement
- Weak entity support
- Standard Inserts storing and sync
- Full documentation capabilities
- Advanced model printing
- Output as image
- All MySQL datatypes with all options
- User defined datatypes
- Database storage, ability to save model within database
- Network-/Multiuser access through database storage
- Version control*
- SQL Query Builder
- SQL Command History
- SQL Command storage within model
- Plugin interface
0 nhận xét:
Đăng nhận xét