Configuring the index service manually

You must run the iBase indexer on a computer with a network connection to the SQL Server instance that contains the iBase database to index.

To set up a search 360 index for a database stored remotely:

  1. In iBase Designer, enable Search 360.

  2. Open a command prompt and run the iBase indexer. For example:

    "i2.iBase.SearchIndexerExe.exe" /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "password" /FullReindex /ShowSummary

The following arguments are valid, but can't all be used at the same time:

iBaseDBName

The name of the iBase database as stored in SQL Server.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password"
ServerName

The server name and SQL instance to access.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password"
Username

The username used to access the database.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password"
Password

The password used to access the database.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password"
FullReindex

This argument can be added to reindex the database.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /FullReindex
ShowSummary

This argument can be added to display a summary of the state of the index after the process finishes.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /ShowSummary
Pause

This argument can be added to pause the indexing at the end of the task that is being processed.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /Pause
DisplayRecordId

This argument can be added to display the Record ID as each record is processed.

Note: Depending on the number of records that are being processed, displaying this information might have performance implications.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /DisplayRecordId
DisplayCallstack

This argument can be added to display the SQL command call stack if an error occurs.

SearchIndexerExe /iBaseDBName "User_Guide" /ServerName "(local)\SQL2019" /UserName "Admin" /Password "Password" /DisplayCallstack