Run the QuestionRevisioningMigration utility as detailed here.
It is important to run this utility before proceeding any further. This utility will migrate question revisioning data from Question table to QuestionHistory table excluding latest question version as is applicable from ExamDeveloper version 7.1807
Please follow the below steps to execute the QuestionRevisioningMigration utility.
Extract the <SVNFolder>\Web\web.zip file into a folder. Here, <SVNFolder> is the path where ExamDeveloper files are going to be checked out, which is C:\ExamDeveloper\Repositories\ExamDeveloper\ in our example.
Extract the <Step a Folder Location>\MigrationExe\QuestionRevisioningMigration.zip file into a folder. Here, <Step a Folder Location> is the path where web.zip files are extracted in the above step a, which is C:\ExamDeveloper\Repositories\ExamDeveloper\Web\web in our example.
Locate QuestionRevisioningMigration.exe in the <Step b Folder Location> folder. Here, <Step b Folder Location> is the path where QuestionRevisioningMigration.zip files are extracted in the above step b, which is C:\ExamDeveloper\Repositories\ExamDeveloper\Web\web\MigrationExe\QuestionRevisioningMigration in our example.
Open cmd and run the following commands cd <Step b Folder Location> QuestionRevisioningMigration.exe "<CONNECTION_STRING>". Here, <CONNECTION_STRING> is your ExamDeveloper database connection string, which is the same as the value of the CONNECTION_STRING token from the secure.properties file. Thus, if your database connection string is "Data Source=WIN-VSGF1NBSVPB; Initial Catalog=ExamDeveloper; Persist Security Info=True; User ID=ExamDev; Password=P@s$w0rd" as in our example, then the command to run would appear as below:
QuestionRevisioningMigration.exe "Data Source=WIN-VSGF1NBSVPB;Initial Catalog=ExamDeveloper;Persist Security Info=True;User ID=ExamDev;Password=P@s$w0rd" Note: Make sure that the connection string is enclosed in double-quotes
This is a long-running process that will take some time.
The command prompt screen will tell you how many Question version update completed and show the progress of migrating question revisioning data. If there were any errors, you can find them here: <Step b Folder Location>\logs\QuestionRevisioningMigration.log and <Step b Folder Location>\logs\QuestionRevisioningMigrationPerformance.log.
Once this is complete, you may continue with the rest of the upgrade process.
ItemGroup Service prerequisites
In this release, we introduced a new Microservice: Item Group. This will be utilized for managing groups of items in future releases.
In order to set it up, we need to configure a new database first.
Open SQL Server Management Studio and connect to the one being used with ExamDeveloper.
Right-click Database node in Object Explorer and select New Database from the context menu.
Name the database Itemgroup on the general tab and accept default settings. If we are using multiple instances in the same server we need to provide different names for each instance like Itemgroup_BETA / Itemgroup_PROD.
Go to Security → Logins, and right-click Properties on the user that is utilized for ExamDeveloper login. For example ED
And assign the same permission to the Itemgroup database.
Enable Snapshot isolation for ItemGroup database name in step e using the following command from Microsoft SQL Server Management Studio:
ALTER DATABASE [ItemGroup] SET ALLOW_SNAPSHOT_ISOLATION ON
Now you are ready to add the property for this connection to the Secure.propertyfile