After updating the FlexiCapture, there is a prompt to update the FlexiCapture Database on the Administration and Monitoring Console > Settings > Application Server page. Can this update be performed manually in case the automatic update using the web interface of the Administration and Monitoring Console fails?
Yes, to update the FlexiCapture Database manually, follow these steps:
- Backup the FlexiCapture Database and FileStorage before updating the Database manually in case of any mistakes.
- Check the current and required Database versions on the Administration and Monitoring Console > Settings > Application Server page.
- Find the required *.sql files in the IIS folder on the computer where the Application Server is installed. Default path: C:\inetpub\wwwroot\FlexiCapture12\Server.
- Find the file named like this: Upgrade<Current_DB_Version>to<Required_DB_Version>.sql. It is possible that the update could include multiple steps. In this case, execute the *.sql files in order.
- Connect to the FlexiCapture Database and execute the required *.sql files.