JavaBeat Certifications Certifications Kits Articles Interview Questions OCAJP 7 OCPJP 5 OCPJP 6 OCEJWCD 6 SCBCD 5.0 SCEA SCJA

MySQL Workbench for Database Change Management

Topic :
Feedback Request New QnA Print Email

Managing database change is an incredibly important discipline that very few database professionals overtly talk or worry about until they're in the thick of things with a particular database - moving it from development to production, making changes to a newly installed production database, or implementing an updated version of the database (new tables, modifications to existing objects, etc.) in a SaaS application. It's at that point where change management becomes very important because if you don't do things right the first time, you can make a royal mess of things and even (in a small number of cases) reach the point of no return where you've completely torched your database.

This is why I've always been a big fan of using good tools when building and managing databases. Yes, some say that tools aren't for real men (or women), but the fact is that the good ones can save you a lot of time, anxiety, and even make you into a hero on occasion. They are also a godsend to novices or non-database pro's who get dragged into being the project DBA for a database-driven project.

With the recent release of MySQL Workbench, you now have at your disposal one of those tools that can really make a difference in how you design and manage databases. You may have thought that data modeling was the only thing that MySQL Workbench could do, and certainly that is the core thrust of the tool. But one of the reasons that I used my data modeling tool so much as a DBA was not for its logical modeling abilities, but for what it could do for me in the area of change management. MySQL Workbench contains a number of database change control features that you may not have noticed at first, so let me introduce them to you and show you why they can be a big help when it comes to managing change in your databases.

http://dev.mysql.com/tech-resources/articles/workbench_database_management.html

Topic :
Feedback Request New QnA Print Email

All api java java 6.0 java 7.0 jdbc jsp servlet ejb jndi jms ejb 3.0 j2ee jee 5.0 jee 6.0 jsf struts spring Hibernate ajax JBoss Seam netbeans eclipse ant xml maven dojo junit javafx j2me log4j ESB JBoss Apache Quartz scjp mysql oracle gwt openjpa jmx yui google-guice android JBoss scwcd 5.0 scjp 1.5 scjp 1.6 scja scbcd 5.0

javabeat | advertise | about us | contact | useful resources
Copyright (2004 - 2013), JavaBeat