To switch to SQL full-text queries

1.Make sure that the SQL Server full-text search engine is installed and running (use Sql Server Configuration manager)

2.Modify appSettings.xml to specify Sql as the full-text engine:

  <add key="Db.FullTextEngine" value="Sql" />

3.Re-import your schema - in this way the system will create the full-text indexes in SQL Server:

  srv4 dbupdate -s <path of schema file> -d ""

4.Restart the IIS with iisreset.

5.Restart Back4 service.

6.Index all the database content:

  srv4 index -conditions gn4:folderObject

or with searchcondition in older versions of GN4:

Srv4 index -conditions search_all.xml

where search_all.xml is the file containing:

<SearchConditions

  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xmlns="http://www.teradp.com/schemas/GN4/1/SearchConditions.xsd"

  ObjectTypeName="folderObject">

</SearchConditions>

This populates a column with the data to index - the actual indexing is done then automatically by SQL Server. It can take a while.

7.Enter full-text searches as usual in the clients, the Web interface and I4: they will be executed by SQL Server. SQL server indexes automatically the data, it is possible that it is still indexing and so the results are not complete - wait some time to have complete results.