Configuring The Message Store Database

<< Click to Display Table of Contents >>

Navigation:  ThinkAutomation Server Configuration >

Configuring The Message Store Database

ThinkAutomation can store processed messages either in its own database or in an external SQL Server database.

 

You can change the format of the Message Store Database by clicking Configure Message Store Database from the ThinkAutomation Server Configuration Manager. The ThinkAutomation Server will need to be stopped before running this option.

 

DBCreate

 

Using the ThinkAutomation Built-In Database Engine

ThinkAutomation can use its own built-in SQLite database engine to store processed messages. This requires no external resources on your PC. It is ideal for small to medium sized businesses.

 

The built-in Message Store Database is located in the C:\Documents and Settings\All Users\Application Data\Parker Software\ThinkAutomation\folder. It is called MessageStore.db3. You can delete this file, provided the ThinkAutomation Administrator and Server are not running. ThinkAutomation will re-create it when it next starts. The built-in database supports unlimited records, however we recommend using the built-in database only for a message store of up to 10GB.

 

 

Using An External Database Server

ThinkAutomation can also use an external Microsoft SQL Server database for the Message Store. This will provide better performance and allow a Message Store of any size. The following database servers can be used:

 

• SQL Server 2008/2012/2014/2016

• SQL Server 2008/2012/2014/2016 Express

 

Using an external database is recommended for larger businesses or if you will be processing many thousands of messages. The SQL Database that you plan to use will need to be installed and running before you select this option.

 

For best performance and ease of setup we recommend using SQL Server 2014/2016 or Express on the same computer as ThinkAutomation.

 

 

ThinkAutomation © Parker Software 2016