Versioning and SQL database

[Joost]

I have a question about versioning of packages when using a SQL database to store your projects.

I have the following setup:

A server with SQL database in which a EA project is stored in a database (on which I used the provided SQL script from the EA resources page).

On server Visual Source Safe Server has been installed to monitor the project file and versioning.

Clients connect to the network share of this server to use source control on the project that is stored in the SQL database.

Check out works ok, when one user checks out a package another user cannot make changes.
All users get an update after a check in etc.

However, when viewing older versions of the model you can only see a diff of the XMI file, which isn't readable at all.

What do I need to do to view a previous version in EA without doing a rollback and lose all my recent changes?

[Eve]

Have a look at EA's baseline functionality.  It includes a comparison tool for between the current state of the model and any saved baseline or EA XMI file.

[Joost]

aah yes, this is the functionality I was looking for, thankyou very much!

I still have a question though. If you create a baseline, is this a version that is saved seperately (in my case in the SQL database) or is the 'show differences' function based on "node" change timestamps that are saved?

[Eve]

Each baseline is a copy of the package of the package at the time it was saved.