Steps to building a R11.2 Test System

2008-06-12T13:37:32Z

Revans:

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

#install the base product
#run the pdm_configure to setup and ensure the environment is correct.
#backup $nx_root/site/mods on the production system
#do the following extract on production
#*pdm_extract wspcol > wspcol.txt
#*pdm_extract wsptab > wsptbl.txt
#restore the wspcol / wsptab to the test system
#*pdm_load -f wspcol.txt
#*pdm_load -f wsptbl.txt
#delete the file $nx_root/site/mods/wsp_schema.log (may not be present)
#log on to the wsp
##open the schema designer
##open any table and make a dummy update (e.g. the description some place)
##choose 'File' -> 'Save and Publish'
##shutdown the Unicenter Service Desk services
##run pdm_publish
##start the Unicenter Service Desk services
##check for any errors
##sign on to Service Desk
##sign on to sql visual studio
##*verify that any schema changes are in place
##check the ddict.sch found in $nxroot\site verify fields are in the ddict
#copy $nx_root/site/mods to the test system (see step 3)
#run the pdm_configure to setup and ensure the environment is correct.
#*check ddict.sch found in $nxroot/site, to make sure that the fields were added correctly
#restore the database using SQL
#change the database name in the following table
#*dlgtsrv table
#*#change the primary server name to the test server name
#*#*sym from production name to test name
#*#*server from production name to test name
#change all the notifications in the usp_contact record to 'Notification'
#*c_cm_id1, c_cm_id2, c_cm_id3, c_cm_id4
#*SQL Command is update dbo.usp_contact SET c_cm_idx = 1801
#reboot the server
#before running pdm_configure, check the following
#*User ServiceDesk is active and available
#*Update ServiceDesk in the SQL database
#apply patches

If any questions on this please email me, danegrey

----
<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

SDU - User contributions [en]

Steps to building a R11.2 Test System