Difference between revisions of "Vital Signs Restore Prior Months"
>Jeremyb |
>Jeremyb |
||
| Line 11: | Line 11: | ||
* Run the LOAD script with the restore parameter followed by the CYMD date for the reports databases that were restored in step 2 | * 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 | ./JVSLOAD_MBRSHLN restore CCYYMMDD | ||
| − | </ | + | </pre> |
(''Where CCYYMMDD is the appropriate month-end value for the data that was restored'') | (''Where CCYYMMDD is the appropriate month-end value for the data that was restored'') | ||
| Line 21: | Line 21: | ||
Step 5. Still logged in as bolive re-run the month-end job to merge all of the extracted months into Vital Signs. | 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 | ./JVSLOAD_MBRSHLN eom CCYYMMDD | ||
(''WHere CCYYMMDD is the prior EOM'') | (''WHere CCYYMMDD is the prior EOM'') | ||
| − | </ | + | </pre> |
Revision as of 22:39, 22 August 2012
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'')
