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.
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.
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.
When a few entities are subgrouped under a particular entity in an entity type, it means those entities share common attributes or relationships.
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:
- 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.