Moving Signup Clients to a new Branch without loosing transactional data.

How can you move Signup Clients (computers) from one Branch to Another without loosing the transactional data?

The only way to move the pc's would be using a sql query.

Note: moved transactions will be assigned to the new group/type that the machine is placed in. The transactions stay with the individual PC.

The following are the tables of interest in the DB:

computers

computer_types

computer_groups
 
From these 3 tables, you can work out which pc is in what group etc.

The following is a query to move a pc:

update computers set computer_type_id = 2, computer_group_id = 2 where computer_id = 2

In my scenario, I wanted to move a pc from Branch 1 in Computer Group 'Default Group' (computer_group = 1) and Computer Type 'Internet' (computer_type = 1) to Branch 2 in a different computer group and type.

After running the above query, a change control would still need to be performed to push the changes to the client pc's.