Using the Full Text Search

In Citavi for DBServer it's possible to add a full text search feature to the SQL Server. This feature can be used with Citavi to index attached files either in the Attachments folder or those saved locally similar to how an online search engine would do it. As a result searching across thousands of attached files is very fast.

By default Citavi indexes PDF and EPub files. For other file types, it depends on which iFilters are available on the client computers (not on the server). Ideally, the same iFilters will be installed and enabled on all client computers. To view iFilters, click Control Panel > Indexing Options > Advanced > File Types.  

As long as Office is installed, the iFilters for the corresponding file types (for example, .docx and .pptx) will also be installed.

In Citavi DBServer Manager check under Actions > Database > Configure full text search if the SQL Server full text search is already installed or not. If you see the notification The full text search is not installed on the SQL server, enable or install the feature.

Please note:

If you used the Citavi program "SQL Server Express for Citavi Setup" and if you're using Microsoft SQL Server Express version 2016 or later, the SQL Server Full Text search is already installed and enabled. If not, please follow the steps below according to your MS SQL server version.

Enabling the SQL Server Full Text Search

If your Microsoft SQL Server is installed with Advanced Services, open the SQL Server installation center and follow the steps under Install Microsoft SQL Server 2019/2017/2016/2014 Express with Advanced Services starting from step 6.

Installing the SQL Server Full Text Search

Install Microsoft SQL Server 2019/2017/2016/2014 Express with advanced services

  1. Log in to Windows using a domain account with administrator rights.
    Important: A non-administrator account that is "elevated" with UAC after starting the Setup will not work.
  2. Download the appropriate Setup from the Microsoft website. You can use the links below to quickly jump to the Microsoft page for the Setup you need:
    1. Microsoft SQL Server 2019 Express
    2. Microsoft SQL Server 2017 Express
    3. Microsoft SQL Server 2016 Express
    4. Microsoft SQL Server 2014 Express
  3. Select the appropriate advanced Setup file, for example ExpressAdv 64-bit\SQLEXPRADV_x64_ENU.exe if the existing SQL Server has an English interface and is running on a computer with a 64-bit operating system.
  4. Extract the Setup file by double-clicking the .exe file you just downloaded. The Setup asks you to select a folder for the extracted files. Usually you will use the Setup program to create a folder in the same folder you saved the Setup file in that has the same name as the Setup program, for example SQLEXPRADV_x64_ENU.
  5. After some time the SQL Server Installation center finishes the extraction and opens automatically.
  6. Under Installation, click New SQL Server stand-alone installation or Add features to an existing installation.
  7. Select Add features to an existing instance of SQL Server 2019/2017/2016/2014 and then select the instance from the drop-down menu, for example CITAVISERVER. Click Next.
  8. In the next step you will see an overview of the available features. Under Instance Features select the Full-Text and Semantic Extractions for Search checkbox and then click Next.
  9. Continue through the rest of the installation.

Install Microsoft SQL Server 2012 Express with Advanced Services

  1. Log in to Windows using a domain account with administrator rights.
    Important: A non-administrator account that is "elevated" with UAC after starting the Setup will not work.
  2. Download the appropriate Setup from the Microsoft website.
  3. Select the appropriate advanced Setup file, for example SQLEXPRADV_x64_ENU.exe if the existing SQL Server has an English interface and is running on a computer with a 64-bit operating system.
  4. Follow the steps under Install Microsoft SQL Server 2019/2017/2016/2014 Express with advanced services  starting from step 3. When extracting the Setup file a temporary folder is automatically created and the SQL Server Installation Center will open. Otherwise the steps are the same as described under Install Microsoft SQL Server 2019/2017/2016/2014 Express with advanced services.

Install Microsoft SQL Server 2008 R2 Express with Advanced Services

If you're using Microsoft SQL Server 2008 R2 Express you will first need to install an upgrade to the SQL Server 2008 R2 Express Edition with Advanced Services. After that, the full text feature is visible and can be installed.

  1. Log in to Windows using a domain account with administrator rights.
    Important: A non-administrator account that is "elevated" with UAC after starting the Setup will not work.
  2. On the Microsoft website, click Download. Select the appropriate advanced Setup file, for example, SQLEXPRADV_x64_ENU.exe if the existing SQL Server has an English interface and is running on a computer with a 64-bit operating system.
  3. Open a command prompt window with administrator rights.
  4. Switch to the folder in which the Setup file was saved and enter the following command line:
    start "" /wait <[Name of the Setup file, for example SQLEXPRADV_x64_ENU.exe]> /ACTION=editionupgrade /INSTANCENAME=<[Instance name, for example CITAVISERVER]> /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQL,RS /INDICATEPROGRESS /Q
  5. After pressing the Enter key, the edition upgrade runs in the background. Wait until the console is available again.
  6. Follow the steps under Install Microsoft SQL Server 2019/2017/2016/2014 Express with advanced services starting from step 3. When extracting the Setup file a temporary folder is automatically created and the SQL Server Installation Center will open. Otherwise the steps are the same.