Reverse Database without Overwritting Entities
When you reverse database, you will find all existing entities are overwritten in the project. This article is going to teach you how to solve this problem.
Pin Specification Window in ERD
/48 Comments/in Database Design /by Visual Paradigm TeamBy pinning, users can read those specification window of various model elements consecutively, no longer have to close the previous specification window and open new specification dialog box repeatedly. Reading the specification window of different entities in ERD now becomes an easy task.
Database Design with Schema
/55 Comments/in Database Design /by Visual Paradigm TeamSince VP-UML supports schema, users can make use of model to manage database. Users can develop ERDs under models, thereby, entities in different models can share the same name, but different schema. This page will demonstrate how to create model, how to create ERD under model and then how to apply schema.
Copy Models across Projects
/47 Comments/in Database Design /by Visual Paradigm TeamUsers can copy and paste models not only between diagrams, but also across projects in VP-UML. This article is going to show you how to copy and paste model across projects within the same application.
How to Model Subtype in ERD
/49 Comments/in Database Design /by Visual Paradigm TeamWhen a few entities are subgrouped under a particular entity in an entity type, it means those entities share common attributes or relationships.
Compare Databases with Visual Diff
/0 Comments/in Database Design /by Visual Paradigm TeamVisual Diff is a feature providing visual comparison between diagrams. We can make use of Visual Diff to compare the structure of different databases. Assume we have 2 databases, Database1 and Database2. To compare different databases:
Using GUID Column in ERD
/44 Comments/in Database Design /by Visual Paradigm TeamGUID (Global Unique Identifier) is a special type of identifier in Microsoft SQL Server, which commonly use for generate unique value for key columns. You can specify column as GUID through the Entity Relationship Diagram (ERD). The steps for specify GUID column is quite simple:
- Specify MS SQL Server as default database server of the project
- Specify the datatype of primary key column as uniqueidentifier
- Change the ID Generator of the primary key column as GUID
The following flash movie demonstrate how to specify the primary key column as GUID.
