| Prev | Next |
Reset Auto Increments
Enterprise Architects models are natively stored in tables in a relational database. It uses the auto-increment feature of these database system when inserting new rows in its system tables. There are a number of operations such as bulk imports and exports from XML files that can cause a table's auto-increment column to approach its largest allowed value. This topic explains how auto-increment issues can arise and what is the best practice for re-sequencing the identifier values in any affected tables.
Impacts
Impact Due To |
Impact |
See also |
|---|---|---|
|
XML Export/Import |
XML Export/Import can cause gaps in the numbering sequence of auto increment columns. Each XML Import deletes rows from several tables; the import then adds rows starting from the largest previous value of the auto increment column. Repeated XML imports can result in the value of the auto increment approaching the maximum value of the database datatype; for example, SQL Server's int datatype has a maximum value of 2,147,483,647. |
Model Exchange in XMI Format |
|
Replication |
Large auto increment values can also arise where the project originated as an QEA or EAP replica or design master. The SQLite and Jet engines assign random values for auto increment columns with each XML Import into the project. These random values can approach the maximum range of the repository data type, which could present a problem when the QEA or EAP project is transferred to another repository. |
Replication |
Access
|
Ribbon |
Settings > Model > Transfer > Full Project Transfer via Native XML > Export Complete Project Settings > Model > Transfer > Full Project Transfer via Native XML > Import Complete Project |
Re-sequence auto increment columns
Step |
Description |
See also |
|---|---|---|
|
1 |
Open the project. |
|
|
2 |
Create a base model of the repository-type that you want to export to. |
The Model Repository |
|
3 |
|
Transfer a Repository in Native Format |
|
4 |
Open the newly created repository. |
|
|
5 |
|
Transfer a Repository in Native Format |
Notes
- It is recommend that this task is performed when there are no active users accessing the Project.