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.

Note: Newly upsized databases in iBase 10 have a randomly generated Database Access Token that must be supplied to Search 360. An example argument is provided below.

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
Database Access Token

This argument is required to provide the Database Access Token for iBase 10 databases.

"i2.iBase.SearchIndexerExe.exe" /iBaseDBName "YourDatabaseName" /ServerName "YourServerName" /Fullreindex /DAT <DAT>"
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