# IT:AD:IQOffice:HowTo:Configure the Standariser #



<callout type="Navigation" class="small">

* [[../|(UP)]]
{{indexmenu>.#2|nsort tsort}}


</callout>


<panel title="Summary">



</panel>


## Process ##

### Preparation

* Know the location of the *.ist file
    * E:\@@@\IQ Office\Maintenance\@@@Stan_Master_Populate.ist
* Have available the following sql scripts:
    * 05_NSI_create_stand_idx.sql


### Process ###



* Double click the *.ist file, to load the IQStandardiser app:

![](https://dl.dropboxusercontent.com/u/11851202/Posted/IT/About/IQOffice/configure_db_connection_02.png)


#### 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 05_NSI_create_stand_idx.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.



## Resources ##