Enhanced Full Text Searching
docMgt version 3.23 and higher has enhanced full text searching support. This feature takes advantage of Microsoft SQL Full Text Indexing engine for faster searching and less space requirements. If you will be doing a lot of full text searching or will have a lot of OCR data to index, you should follow these instructions to enable this support.
Requirements
You need to be running docMgt version 3.23 or higher in an on-premise server installation. If you are hosted in the cloud contact support to ensure you have the best configuration for your needs. You will also need to be running SQL Server 2012 or higher and have the SQL Full Text Engine installed.
This change is done entirely at the database level.
You must NOT already have existing OCR (Full Text) data stored in your docMgt database. If you follow this process while you have existing Full Text data you will no longer be able to search based on your old data. If you have existing Full Text data then you will need to convert the existing OCR data from the DocumentFullText table to this new format. Contact support for help with this. Don’t fret if you already performed these actions. As long as you did not delete your DocumentFullText table your OCR data is safe. Contact support ASAP to convert your old data to the new format.
One other suggested practice is to restore your latest backup into a new database and run through this article using the backup database and not live. If all goes well then you should be able to run it on your live system with more confidence.
Setting Up SQL Server
The first thing you need to do is make sure you have a full backup of your database. Once that is done, ensure you have the Full Text Engine installed for Microsoft SQL. If you have any questions about whether or not you have SQL Full Text Indexing installed, refer to this article (notice, external link not under our control).
https://www.techrepublic.com/blog/data-center/adding-sql-full-text-search-to-an-existing-sql-server/
Setting Up the docMgt Database
Once you have everything in place for SQL server itself, it is time to configure the docMgt database correctly. Run the attached script in your docMgt database to tell docMgt to use the new full text indexing scheme.
New Full Text Searching Update (ZIP – Download and Extract)
If you receive any errors running the script contact support immediately.
You Are Done
Now that you have made the change to the database you are docMgt will see your DB structure and know that you are using the new full text method. There is nothing else to configure to make it all work.
Remember, if you have existing data that needs to be convert, contact support. We have a utility designed for converting from the old format to the new that we can help you run to get all your data ready to use.
Related Articles
How to Install and Configure docMgt OCR
Importer Service Tips and Tricks!