Copy Computers/Groups to another Deployment Server

Products

• Deployment Solution

Issue/Introduction

 

Resolution

Question

I am building a new Deployment Server.  How can I copy all of the groups and computers from my old Deployment Server to my new Deployment Server?

Answer

The SQL query below is an example of how to complete this.  The first script will be used to create the groups on the new server.  The second script will be used to add the computers to the proper groups.  This example assumes both Deployment Databases are housed within the same SQL server.

neweXpress: Represents the name of the eXpress database the new Deployment Server is connected to and must be changed appropriately.
oldeXpress:  Represents the name of the eXpress database the old Deployment Server is connected to and must be changed appropriately.

-- Begin script to recreate the groups
-----------------------------
INSERT INTO neweXpress.dbo.computer_group
SELECT     *
FROM         oldeXpress.dbo.computer_group
WHERE     (group_id NOT IN
             (SELECT group_id
                 FROM neweXpress.dbo.computer_group))
-----------------------------
-- End script to recreate the groups

-- Begin script to move the computers into the correct groups
----------------------------------------------------
UPDATE neweXpress.dbo.computer
SET group_id= oldeXpress.dbo.computer.group_id, name= oldeXpress.dbo.computer.name
FROM neweXpress.dbo.computer INNER JOIN oldeXpress.dbo.computer
ON neweXpress.dbo.computer.computer_name = oldeXpress.dbo.computer.computer_name
WHERE oldeXpress.dbo.computer.group_id IS NOT NULL
----------------------------------------------------
-- End script to move the computers into the correct groups

The computers and groups will now show up in the new Deployment Server. 
The computers listed in the new Deployment Server will not be able to have jobs sent to them until the AClient has been pointed to the new server for each of the computers.