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.

Read more

Pin Specification Window in ERD

By 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.

Read more

Database Design with Schema

Since 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.

Read more

Copy Models across Projects

Users 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.

Read more

How to Model Subtype in ERD

When a few entities are subgrouped under a particular entity in an entity type, it means those entities share common attributes or relationships.

Read more

Compare Databases with Visual Diff

Visual 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:

Read more

Using GUID Column in ERD

GUID (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:

  1. Specify MS SQL Server as default database server of the project
  2. Specify the datatype of primary key column as uniqueidentifier
  3. 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.