I am searching (but not finding) How to Migrate a WDM Workgroup Server from one server to another.
Because tha actual server is not only used for WDM, I want to move my WDM onto another fresh Windows Server; but I don't want to lost all my devices list, all my sevices settings, ...
So my question is : someone has seen a page about that case ? (I suppose I am not the only one).
I am sure that is not only a WDM DB copy/past and WDM Repository copyt/past.
I will appraciate your help.
Sorry to say, but WDM Workgroup does not have any migration capabilities built in and since the IP address, the server name and many other parameters are integrated in the database, the only realistic migration option is to re-install. I have not seen any documentation or instructions on migrating a Workgroup server.
Here are some helpful links:
Moving the Wyse Device Manager DatabaseOn the Old SQL server1. Detach the Database:2. Stop the SQL Service3. Navigate to folder containing WDM Database filesa. Default WDM 4.5.x - c:\Program Files\Wyse\WDM\Databaseb. Default Rapport 4.4.x – c:\Program Files\Rapport\Database4. Make copy of the Rapport4.mdf and Rapport4.ldf files5. Move Rapport4.mdf and Rapport4.ldf files to location accessible by new SQL ServerOn the New SQL server1. Attach the Database:2. Move a copy of the Rapport4.ldf and Rapport4.mdf files to a directory on the server where for usewith SQL.a. *Default SQL location - c:\Program Files\Microsoft SQL Server\MSSQL\Datab. Default WDM 4.5.x - c:\Program Files\Wyse\WDM\Databasec. Default Rapport 4.4.x – c:\Program Files\Rapport\Database3. Open the SQL Enterprise Manager Tool Login as ‘SA’ account (or another account with DBAdmin rights)4. Navigate to the Server or Instance that you are going to install the new Database.5. Expand the Database node6. Choose the option to “Attach Database” (from right-click or icon)7. Browse out to the location of the newly copied Rapport4.mdf/.ldf8. Attach the Database name as “RapportDB”9. Specify “SA” as the Database Owner10. Select OK to attach the database.11. Configure the Database User:12. Expand the newly attached RapportDB database13. Select the Users node under RapportDB14. Create new SQL user account “Rapport” (SQL Server Authentication)a. Set Password to “ThinMgmt_451”b. Set Default Database to “RapportDB”c. Uncheck option to Enforce Password Policy if needed15. Select Ok to create the new user (confirm password if prompted)16. Select the newly Created Rapport user account from the Login name drop-down. (Login name andUser name should both appear as “Rapport”17. Grant db_owner access to the Rapport account by selecting the checkbox18. Click OK to finish adding the Rapport account with db_owner access to the RapportDB database.19. Update Install Table:20. Select the Tables node from under RapportDB21. Scroll down to the “Install” table22. Right-click on “Install” and choose Open Table > Return all rows23. Create\Update the following entries:a. Module = Rapport4DBb. ServerName = %COMPUTERNAME% of machine including DNS suffix if enabled onserver (i.e. WDM-server.mycompany.com)24. Close “Install” table25. Update Server Table:26. Open “Server” table27. Delete contents of “Server” table28. Close “Server” table29. Check Stored Procedure Permission30. Expand SQL node for Stored Procedures31. Locate column for ‘Owner’32. Sort by ‘Owner’33. Verify all entries for ‘Owner’ are “dbo”34. Reset owner on any stored procedure not set to “dbo”*The following sample SQL queries can be used to change owner of stored procedure:exec sp_changeobjectowner 'rapport.sp_AddUpdateImportClient', 'dbo'exec sp_changeobjectowner 'rapport.sp_BlazerHeartBeat', 'dbo'exec sp_changeobjectowner 'rapport.sp_createsubnetlevels', 'dbo'exec sp_changeobjectowner 'rapport.sp_GetClientValues', 'dbo'exec sp_changeobjectowner 'rapport.sp_GetJobRepositoryInfo', 'dbo'exec sp_changeobjectowner 'rapport.sp_GetJobStatusInfo', 'dbo'exec sp_changeobjectowner 'rapport.sp_OverrideCache', 'dbo'exec sp_changeobjectowner 'rapport.sp_UpdateImportClientStatus', 'dbo'35. DB Migration Complete