> My question is what's the best way to swap settings between the two
> computer records and swap any software installed? Ideally I'd like it
> in the form of a function where I can pass the two p_id's and return a
> boolean reflecting success (true) or fail (false).
I'd say something like that (generic table names) :
If you're confident :
UPDATE stuff SET owner = (CASE IF owner='A' THEN 'B' ELSE 'A' END) WHERE
owner IN ('A','B')
If you're paranoid :
UPDATE stuff SET owner = (CASE IF owner='A' THEN 'B' ELSE IF owner='B'
THEN 'A' ELSE owner END) WHERE owner IN ('A','B')