Revision of UML-Model in database

[ufechner]

Hello,

if we store the UML Modell in an sql database, e.g. MySQL, using transactions:

In this case it SHOULD be possible to have a revision number of the model, that is automatically calculated.

Is this sort of mechanism already implemented?

Working with audit trails would only be useful for us, if there would be a way, to identify a curtain revision of the model. This revision number should be included in the printouts.

Is this already possible, or do I have to write a feature request?

A timestamp is not really usefull, because it can easily happen, that a pc doesn't have the correct time, or that different pc's in a team have different times.

Regards:

Uwe Fechner

[Martin Terreni]

I think it is a good idea, bit what about using configuration control?
We use TFS and you have a number for each checkin of the file, so you actualy have a revision.

[ufechner]

We want to use EA together with RA-Quest.
RA-Quest already allows to audit changes of requirements and to restore old versions of a requirement.

Therefore I would prefer to avoid using an external version control system for the model.
(We keep the code in SVN.)

For our development cycle it would be sufficient to use the audit logs during the development of a new version and to create a baseline for each released version.

Regards:

Uwe Fechner

[Martin Terreni]

If you work on a DB which allows triggering (like MSSQL) you can create a trigger on each table and a log for each.
the trigger would send the change to the log with an automatically created revision number. I don't know RA quest (we work with Doors), but maybe you could even import the revision number from there (or export it to RA quest)
Then you could easily create an external tool to roll back objects\packages to previous revisions state.

A little complicated, but not something a developer can't do in 3 days work.  

[bmioch]

ufechner,

In regards to your concerns about different times, Auditing provides an option to use the DBMS time for all transactions.

http://www.sparxsystems.com.au/EAUserGuide/index.html?auditing_settings.htm

If you check Use Database Timestamp, then all timestamps will be taken from the Database Server.

This setting is not available for EAP files, since they are file based, not server based.

Bill

[Martin Terreni]

Now that I remember, if you work with version control all the objects in DB have the same revision number of each check in (if it is of any help).
You cna see the number if you enter file history.