On release 7.1906 we modified the SQL functions for Strip Sensitive Data to sending the obfuscated database copy for defect analysis.

If the application migrated to 1906 and above release but not updated the Strip Sensitive Data script, please follow the instructions document Strip Sensitive Data Instructions to update the same.

 

  1. Ensure that the self-hosted.properties file updated in steps 1 and 2 of Upgrading from 7.1704 to 7.1705 is placed in folder C:\EnvProp\. Also, ensure that the secure.properties file created in step 3 of Upgrading from 7.1704 to 7.1705 is placed in folder C:\SecProp\.
  2. We are Migrating the application and from below 7.1807 to 7.1807 or higher version we need to execute this step and create Itemgroup DB. If we already created Itemgroup DB we can skip this step.

     

    1. From 1807 release, we introduced a new Microservice: Item Group. This will be utilized for managing groups of items in future releases.

    2. In order to set it up, we need to configure a new database first.

    3. Open SQL Server Management Studio and connect to the one being used with ExamDeveloper.

    4. Right-click Database node in Object Explorer and select New Database from the context menu.

    5. Name the database Itemgroup on the general tab and accept the default settings. If we are using multiple instances in the same server we need to provide different names for each instance like for example Itemgroup_BETA / Itemgroup_PROD.

    6. Go to Security → Logins, and right-click Properties on the user that is utilized for ExamDeveloper login. For example; ED is shown in below picture

    7. Assign the same permissions given to another database to the Itemgroup database.

    8. Enable Snapshot isolation for ItemGroup database name in step e using the following commands tougher from Microsoft SQL Server Management Studio :

      ALTER DATABASE [ItemGroup]

      SET ALLOW_SNAPSHOT_ISOLATION ON

  3. Create SVNScript folder in D drive.
  4. Download the Migrate-SVNClient.ps1 script file and save it on D:\SVNScript \. (see attachment Migrate SVN clients to Target location)

  5. Open Windows PowerShell as Administrator. Change the location of the script to be located inside D:\SVNScript folder.

  6. Bypass the PowerShell execution policy with the following command and press enter, while asking the confirmation press "y" and enter:

    Set-ExecutionPolicy bypass
  7. While setting versions in point f above, instead of 1805 we need to use 1805.1 and also instead of 1809 we need use 1809.01

     

    Run the command ./Migrate-SVNClient.ps1 -download -installServices -installWebApplication -SVNFilesDownloadPath D:\SVNScript -instanceName 'Standard' -versions <Version List>. where are Version List is versions of current version to It will start to upgrade the application to the target version. 
    If current version is 1911 and we are migrating the application from 1911 to 1912 command will be ./Migrate-SVNClient.ps1 -download -installServices -installWebApplication -SVNFilesDownloadPath D:\SVNScript -currentVersion "1911" -targetVersion "1912" -instanceName "Standard"

    1. download: This flag will be used to download files from the SVN repository to a local folder. while doing the second instance (SideBySide) in the same server we can remove this flag from the command because files already downloaded with the 1st upgrade. 
    2. installServices: This flag to indicate to install the Service.
    3. installWebApplication: This flag to indicate to install the web application.
    4. SVNFilesDownloadPath : Location, where we are downloading the SVN files in our example location, is D:\SVNScript from point 1.
    5. currentVersion : current client application release number. In the above command example, client current release is 1911
    6. targetVersionWhere client planing to upgrade the application. In the above command example, client planed target release is 1912

    7. instanceName: This is an optional parameter, if we are running the multiple instances in the same server we need to pass this value, this instance name will be collected from APP_RELATIVE_URI_PREFIX= key value from the self-hosted properties files. In this example instance name client represented the Multiple (SideBySide) instances in the same server, it will be like Beta / Prod/client Etc.
  8. While executing the script please follow the screen instructions below:

    1. First, It will download the available svn repository files between the current and target versions.

    2. Next, it will prompt the service user credentials please provide them along with domain name like below screenshot
      (created in step 3 of Upgrading from 7.1702 to 7.1704)

      Please ensure that the User name is entered in the "domain-name\username" format; in our example, it is "WIN10-PC\Administrator".

    3. Next, It will prompt for environment.properties files like below:
    4. After click OK it will open file open dialog box like below please set the path and select the self-hosted.properties file and click open:
    5. Next, It will prompt for secure.properties files like below:
    6. After click OK it will open file open dialog box like below please set the path and select the secure.properties file and click open:
    7. After selected the secure properties files it will start running migration script if any.
    8. Next, it will uninstall all the existing installed services.
    9. Next, It will install all the services.
    10. Next, It will install the web application.
    11. Finally, it will upload the report files and successfully complete the upgrade process.
  9. QuestionRevisioningMigration utility will migrate user tracking data for the project shared questions. Follow the steps below to execute the QuestionRevisioningMigration utility.

    1. Open Command prompt as Administrator. 

    2. Change folder location to D:\SVNScript \7.1903\web\web\QuestionRevisioningMigration.

    3. Type QuestionRevisioningMigration.exe <CONNECTION_STRING> "projectshare" and press Enter, <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.

      Example: QuestionRevisioningMigration.exe "Data Source=WIN-VSGF1NBSVPB;Initial Catalog=ExamDeveloper;Persist Security Info=True;User ID=ExamDev;Password=P@s$w0rd" "projectshare"

    4. This is a long-running process that will take some time based on the data available in the database. 

    5. The command prompt screen will tell you how many Question version updates completed and show the progress of migrating question revisioning data. 

    6. If there were any error, you can find them here: D:\SVNScript\7.1903\web\QuestionRevisioningMigration\logs\QuestionRevisioningMigration.log and D:\SVNScript\7.1903\web\QuestionRevisioningMigration\logs\QuestionRevisioningMigrationPerformance.log.

Please follow the instructions in Uninstall service using command prompt to uninstall service manually.