Bulk change of relationships

[Michel777]

Hi,

there is  70 use cases, 100 components and 500 relationships between them ( trace). Sometimes in both directions .

Question: how to change the relationship  "trace" into "association" ?

Thanks,

Michel

[qwerty]

You should do that with a SQL like

Code: [Select]

UPDTAE t_connector SET connector_type = "Dependency", stereotype = "trace" WHERE connector_type = associationif it's only relevant associations. Eventually you could export a package with only the elements you want to change, import them in a temp model, run the SQL, and ex-/import them back.

q.

[motivatedgorilla]

I thought we couldn't run UPDATE from within Sparx

[Geert Bellekens]

You can execute an update statement either directly on the database, or via a script using the hidden operation Repository.Execute(String sqlQuery)

Geert

PS. Be careful with that. It is very easy to completely f*ck up your model this way

[Sorno]

Might not be as neat, but if SQL is too daring - why don't script it?

I have found it very useful to have a basic script that can run through a complete model or certain package and apply some kind of a fix on each element/connector matching some criteria.

If it's a one-time thing the speed of the script dosn't feel like such a big deal.