![]() Here’s an example: This EER diagram was generated by reverse engineering a database and its objects.To be up to date for upper versions and later visitors :Ĭurrently I'm working on a win7 64bit having different tools on it including python 2.7.4 as a prerequisite for google android. ![]() The EER diagram is now displayed on the screen. It outlines everything that was reverse engineered. Click Close: This is the final summary of the process. Click Continue: The “Reverse Engineering Progress” screen simply informs you that the wizard is performing the reverse engineering process and generating the EER diagram (behind the scenes). MySQL Workbench will now reverse engineer all selected objects and generate the EER diagram (behind the scenes). If the database contained more objects, they’d be listed here. The database in this example is simple and only contains 3 tables. Select the database objects you’d like to have reverse engineered, then click Execute: The “Select Objects to Reverse Engineer” screen allows you to select the objects yo’d like to reverse engineer. Click Continue: The “Retrieve and Reverse Engineer Schema Objects” screen simply informs you that it has in fact, retrieved the objects from the database/s. MySQL Workbench will retrieve all objects from the selected schema/s and check the results. You can reverse engineer any of the schemas listed. ![]() Select the database/s you would like to reverse engineer, then click Continue: The “Select Schemas” screen prompts you to select the schema/s you’d like to engineer. Once it has connected to the DBMS specified in the previous step, it will display this screen. Click Continue: The “Connect to DBMS and Fetch Information” screen. Workbench will connect to the DBMS, fetch a list of databases, and check for any issues. It will typically be the password you use when connecting to the instance via MySQL Workbench: The Password prompt. This is the password required to make the connection. Enter PasswordĮnter password if required, then click OK. Set/review parameters for connecting to the DBMS then click Continue: Here you enter the details of the DBMS that contains the database that you wish to reverse engineer. Selecting “Reverse Engineer” from the “Database” menu starts the process. ![]() You don’t need to be connected to any MySQL instance at this stage – the wizard will ask you to connect at the next step. Select Database > Reverse Engineer from the top menu of MySQL Workbench. The EER diagram is now displayed on the screen.īelow are screenshots for the above steps. The wizard will now reverse engineer all selected objects and generate the EER diagram (behind the scenes).Select the database objects you’d like to have reverse engineered, then click Execute.The wizard will retrieve all objects from the selected schema/s and check the results.Select the database/s you would like to reverse engineer, then click Continue.The wizard will connect to the DBMS, fetch a list of databases, and check for any issues.Enter password if required, then click OK. ![]() Set/review parameters for connecting to the DBMS then click Continue.Select Database > Reverse Engineer from the top menu of MySQL Workbench.To reverse engineer a database in MySQL Workbench: ![]()
0 Comments
Leave a Reply. |