Export database design to Excel for mass editing
Sometime, we need to perform large scale modification or validation of database design. While the diagramming interface is good for designing and understanding database design, it's not efficient enough for performing large scale changes. This tutorial shows how to export ERD to Microsoft Excel file, modify the Excel and import it back to the ERD.
Topics
1. Export ERD to MS Excel file
2. Make changes in Excel
3. Import Excel file back to ERD
| September 1, 2009 | |
User Rating:
/ 1
|
|
| Views: 2,494 | |
|
PDF
Link
Link: |
Add comments |
The database design for the Computer Sales project:
- To export the diagram as excel, right click on the diagram, and select Export > Export to Excel... from the pop-up menu.
- Specify the path of the Excel file.
- Select Model Type Per Sheet as the Export Style.
- Let's open the exported file.
- Open the Entity sheet.
- Remove all the _ in the Name column, and press Save.
- Back to the DB-VA.
- Select File > Import > Excel... from the main menu.
- Select the modified Excel file.
- The changes are listed in the Import dialog box. Review them and click OK to perform.
- The changes are applied to the diagram.
Download full functions 30 days FREE trial of DB Visual ARCHITECT
Notes:
1. Select DB Visual ARCHITECT 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).
Microsoft, Microsoft Excel, MS Word and Microsoft SQL Server are U.S. registered trademark of Microsoft Corporation
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)