Steps to building a R11.2 Test System
The following are the steps I have used to build several test systems.
It involves getting a sql backup of mdb, with all login's in the backup and then restoring is to a test system that has been setup and have an existing mdb built. The existing mdb is copied over using the SQL restore.
Steps to go from migrated R11.x system to a R11 test system
1 install the base product
2 run the pdm_configure to setup and ensure the environment is correct.
3 backup $nxroot/site/mods on the production system
4 do the following extract on production
4.1 pdm_extract wspcol > wspcol.txt
4.2 pdm_extract wsptab > wsptab.txt
5 restore the wspcol / wsptab to the test system
5.1 pdm_load -f wspcol.txt
5.2 pdm_load -f wsptbl.txt
6 delete the file $nxroot/site/mods/wsp_schema.log (maybe not present)
7 log on to the wsp
7.1 open the schema designer
7.2 open any table and make a dummy update (e.g. the description some place)
7.3 choose 'File' -> 'Save and Publish'
7.4 shutdown the Unicenter Service Desk services
7.5 run pdm_publish
7.6 start the Unicenter Service Desk services
7.7 check for any errors
7.8 sign on to Service Desk
7.9 sign on to sql visual studio
7.9.1 verify that any schema changes are in place
7.10 check the ddict.sch found in $nxroot\site verify fields are in the ddict
8 copy $nxroot/site/mods to the test system (see step 3)
9 run the pdm_configure to setup and ensure the environment is correct.
9.1 check ddict.sch found in $nxroot/site, to make sure that the fields were added correctly
10 restore the database using SQL
11 change the database name in the following table
11.1 dlgtsrv table
11.1.2 change the primary server name to the test server name
11.1.2.1 sym from production name to test name
11.1.2.2 server from production name to test name
12 change all the notifications in the usp_contact record to 'Notification'
12.1 c_cm_id1, c_cm_id2, c_cm_id3, c_cm_id4
12.2 SQL Command is update dbo.usp_contact SET c_cm_idx = 1801
13 reboot the server
14 before running pdm_configure, check the following
15.1 User ServiceDesk is active and available
15.2 Update ServiceDesk in the SQL database
20 Patches apply patches
If any questions on this please email me.....
