Automate reversal and removal of connectors

[szucconi]

Is there any simple way to reverse or remove a connector through the repository object?  If not, are there any known issuse with making these changes to the database directly?  I can access the connector I want to reverse, but I can't seem to find the proper call to reverse it.

[KP]

Is there any simple way to reverse or remove a connector through the repository object?  If not, are there any known issuse with making these changes to the database directly?  I can access the connector I want to reverse, but I can't seem to find the proper call to reverse it.

I think you need swap the values of ClientID and SupplierID and possibly also ClientEnd and SupplierEnd. (nb I haven't tested this so make backups before you try it!)

[szucconi]

I did it manualy and tested it on a test db and it seemed to work.  

I connected to the db using the connectionstring from the repository and used an sql update query to swap the source and dest members.  I copied the data from a sample connector and then did a reverse arrow and compared it with the new data to find the members that needed to be swaped.

The part that I am unsure about now is removal.  Will simple using a delete query on the connector do any damage to the rest of the project?

[KP]

The part that I am unsure about now is removal.  Will simple using a delete query on the connector do any damage to the rest of the project?

Maybe...

Each connector will have one record in the t_connector table, but may have multiple records in the t_diagramlinks table (one for each diagram it appears on), multiple records in the t_connectortag table, and possibly other information hidden away elsewhere too.

Your best bet is in automation: get the Element at one end or the other and use the Element.Connectors.Delete() or DeleteAt() method. That will guarantee a clean deletion.

Enjoy!