Editing / updating components via SQL

[Christian Czaia [Decadis AG]]

Hey,

we have a large list of components. Now I have to add about 200 new components. Are there any dependencies that I have to be aware of?

My plan would be do do a manual insert of the new components adding a consecutive ID. Would be during a downtime to prevent other users to add components during that time.

Any help is being appreciated

Cheers

Christian

[JohnA · Accepted solution]

Hi Christian,

Another popular option for automating these kind of tasks is to use Bob Swift's Command Line Interface plugin, and in your case you could use either the addComponent or updateComponent options as described in this docment: https://bobswift.atlassian.net/wiki/display/JCLI/Examples

All the best,
John

[Udo Brand]

Hi Christain,

I would be using jelly with AddComponent. Then you would not need to think about downtime and dependencies.

Cheers,

Udo

[Christian Czaia [Decadis AG]]

Thanks, but we're dealing with about 800 components. It's sag though, that you can't archive components like versions... I've voted on that issue too :-)

[David Chan]

Just wanted to add that having a large (massively large) number of components has been found to result in some performance degration: https://jira.atlassian.com/browse/JRA-31883