Vital Signs Restore Prior Months

From Vital Soft Wiki
Revision as of 22:39, 22 August 2012 by >Jeremyb
Jump to: navigation, search

Step 1. Configure the Restore Eloquence Instance

  • Login as askplus
  • Modify the Eloquence Instance set for EQ_DBSERVER in the vsrvtcp.ini profile [vsdata_live_restore]

Step 2. Restore the desired membrs.report and membr2.report databases to the Eloquence instance you selected in the prior step.

Step 3. Extract multiple EOMs

  • Login as bolive
  • Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2
  ./JVSLOAD_MBRSHLN restore CCYYMMDD

(Where CCYYMMDD is the appropriate month-end value for the data that was restored)

Step 4. Repeat steps 2 and 3 for all the months that you want to load.

Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs.

./JVSLOAD_MBRSHLN eom CCYYMMDD
(''WHere CCYYMMDD is the prior EOM'')