It's Importent to know If it's version 6 or 7 since it's different solution for each version

Ilan

I would  prefer to instruct you  the easy way and not complicate the solution with a lot of sqls (please run this solution first on the backup database..

1. Duplicate the source box with all the strips terminals and channels.
2. Move from the source i/o card (from all the cards that need to move to the second box)the  cs_tag (don’t delete anything like strip channels and terminals from the  first box).
3. Modify the second box with the right strip (delete what belong to the first box).
4. Update the second box i/o card with the right cs_tags in the channels.
5. Connect to the domain schema and run the following sql:

Select p.panel_id,p.panel_name,s.strip_id,s.strip_name from panel p,panel_strip s where p.panel_id = s.panel_id and p.panel_name

in(‘First box name’,’second box name’) and s.strip_name (‘strip1_name’,strip1_name,’etc’) order by s.strip_name,p.panel_name;

strip name should be the strip that you like to move the connection to the second box.

6. when you have the list of the strips from the source box and from the second box you can update in the wire_terminal the right panel_id and

strip_id and move in this way the connection to the second box:

update wire_terminal set panel_id = <the second box panel id> ,strip_id = < strip_id for the first strip in the second box >  where panel_id =

<first box panel_id> and strip_id < first strip that you wish to move to the second box>;

Continue with same idea and run command for the second strip etc.

7. Make sure the connection move to the second box strip and you can delete the strip from the first box.

Regards

Ilan Hills