Run Upgrade Application
The Reveal AI Upgrade Application is part of installation and needs to be run for new installation as well as upgrade.
Copy “03.Processing\NexlpDatabaseUpgrade” to a server that can access Reveal AI SQL server.
Edit the “NexLP.Upgrade.exe.config” file, update the following lines properly to match the environment if needed:
ID
Name
Details
1
RootFolder
points to the folder that contains the update scripts, by default it is “.\UpgradeScripts”
2
IgnoreStorybookIds
ID of story books to ignore, separated by “,” - For example, “100010,100020”
3
VerboseLogging
Set Yes to indicate a verbose logging
4
ExecutionQueryTimeout
Query execution timeout in Seconds
5
ResultFile
Location of the log file
In the same config file, find the “<ConnectionStrings>” section; set a proper connection string so that the upgrade application can connect to the NexLP Admin database correctly. For example,
<connectionStrings>
<add name="NexLPAdmin" connectionString="Server=localhost;Database=NexLPAdmin;Integrated Security=SSPI;Connection Timeout=120" providerName="System.Data.SqlClient" />
</connectionStrings>
Open a command line Window in Admin mode, browse to the folder where you extract the files, run the following command:
C:\NexLP\2.90\NexlpUpgrade_2.90\03.Processing\NexLPDatabaseUpgrade\NexLP.Upgrade.exe
After the upgrade finishes, open the result file (you can check the config file to find the location of the result file) and confirm there are no failures during upgrade.