IT:AD:IQOffice:HowTo:Configure the Standariser
Summary
Process
Preparation
- Know the location of the .ist file * E:\@@@\IQ Office\Maintenance\@@@StanMasterPopulate.ist Have available the following sql scripts:
- 05NSIcreatestandidx.sql
Process
- Double click the *.ist file, to load the IQStandardiser app:
Connection Strings
* Ensure the connection strings are correct for:
- Input
- Output
Standardize
* Click Configuration > Run.
- This process will populate the IQ_stand table.
- It will take a long time…
Index
* When the standardisation is complete, it needs to be indexed.
- Using SMMS, load up the 05NSIcreatestandidx.sql
- Run it.
- It will take a long time…
Cleanup
The Database Log will have grown substantially during the previous process.
Clean it up:
- In SSMS
- Select the database:
- Right click the database, select
Database Properties -> Options tab - Ensure that the
Recovery Mode=Simple - Right click the database, select
Tasks -> Shrink -> Files- Ensure that the
Recovery Mode=Log - Press Ok, and let it run.