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:
Argument Description Example
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