Generate database change script
In order to patch existing database to newer version, database administrator need to prepare DDL (Data Definition Language) scripts with commands of updates. VP-UML is capable in updating database, or just to generate the DDL required, by comparing differences between the design, which is the ERD(s), and the database, and to generate the DDL scripts accordingly. In addition to generating update scripts, VP-UML can also generate scripts for creating and dropping database. In this tutorial, we will focus on generating the update scripts.
Topics
1. Update database design - the ERD
2. Generate database scripts for "Update Database"
3. Execute scripts in Oracle
| September 1, 2009 | |
User Rating:
/ 0
|
|
| Views: 2,236 | |
|
PDF
Link
Link: |
Add comments |
| Edition: Standard or above (Edition comparison) | |
The original database design for the Computer Sales project:
- Let's update the design. Rename entity Addresses to Customer_Addresses.
- Add a new column to entity Computer_Part by right clicking on it and selecting New Column from the popup menu.
- Enter discount : numeric(8, 2) as the column definition, press the Enter key and then the Esc key to confirm editing.
- Move the mouse cursor over Computer_Part, press on the One-to-Many Relationship -> Entity icon in the resource-centric interface, and drag to the empty region to create a new entity. Enter Part_Usage as entity name.
- Rename the automatically created FK (foreign key) column to part_id.
- Repeat the previous steps to add the following columns to Part_Usage.
- +usage_id : number(10)
- description : varchar2(1024)
- The design is now updated. To generate the scripts of changes, select Tools > Database > Generate Database... from the main menu.
- In the Database Code Generation dialog box, specify the output path of the DDL script file.
- Select Update Database as the type of generation.
- Un-check Export to database to make it generate scripts file only.
- Click OK to start generation.
- The script is generated to the given path.
- Let's take a look at the generated scripts.
- To execute the scripts, open the Oracle Web client, select SQL > SQL Scripts, and click Upload to upload the generated DDL file.
- Once the file is uploaded, click the script icon.
- Click Run to execute the scripts to database.
- Click Run again to confirm.
- Click the file icon to check the result.
- The scripts are executed successfully. Database is updated.
- We can see the changes in the Object Browser.
Download full functions 30 days FREE trial of Visual Paradigm for UML
Notes:
1. Select Visual Paradigm for UML when installing the VP Suite.
2. Click "Try without Evaluation Key" button to get 30 minutes per session evaluation.
3. Click "Request Key" to get a 30-day evaluation key by email (Your email will only be used for sending evaluation key and follow up your evaluation. We will NEVER share your email to third party without your approval).
Oracle is U.S. registered trademark of Oracle Corporation
Rate this Article
Click on one of the stars below to rate this article from 1 (lowest) to 5 (highest).
Comments (0)