View source for Vital Signs Restore Prior Months

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]

<pre>
[vsdata_live_restore]
login=bolive
Directory=/home/users/bolive/vsdata
TEMP=/home/users/bolive/vsdata/temp
EQ_DBSERVER=localhost:eloq-TEST
script_path=/ASKPLUS/vsdata/scripts
custom_path=/ASKPLUS/vsdata/custom/live
Vmgr=/ASKPLUS/vsdata/custom/live/vmgr_eom
</pre>

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

<pre>
  ./JVSLOAD_MBRSHLN restore CCYYMMDD
</pre>

(''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.

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