| Subject: | Add the ability to automatically upgrade DEMO and NEW Data structures with each new release |
| Summary: | Problem: The NEW and DEMO database have to be built on every patch and new version release. This takes a lot of time and is prone to mistakes. Further Details: Since we are building an upgrade script, we can use the single upgrade script to upgrade NEW and DEMO builds instead of rebuilding the NEW and DEMO Builds. This will save us a significant amount of time in releasing versions. Possible issues: When a new or Demo build is created, the system will check if the database needs to be upgraded. If so, the upgrade form will popup and the user has to select the option to "Apply Scripts". The demo/New database will then be upgraded. |
| Audit Notes: | |
| 30 May 2018 | 09:41AM Comment 1 by Sanjay (Link Technologies) Case 9315 added to project 09.4 |
| 30 May 2018 | 09:42AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-05-2018 09:42 AM Time Taken: 7.00 |
| Development work for this case has been completed. The change will be available in version: 944 BETA4 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Add a check at the end of NEW/DEMO build to check application and Database version. The upgrade form is loaded automatically with preset values so the user can apply the upgrade scripts.
- Added SERVER and Database name to the UPGRADE form so the user can see which database is being upgraded
2. The issue was caused by: - NA
3. Next Step - UAT
|
|
| 04 Jun 2018 | 03:02PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 04-06-2018 03:02 PM Time Taken: 1.00 |
| System test completed. Verified after the new/demo database is installed, the system prompted upgrade screen.
|
|
| 05 Jun 2018 | 08:16AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-06-2018 12:00 AM Time Taken: 1.00 |
| Hi Sanjay, This case has been successfully tested. Documentation on the case has completed - Installation - New Database Setup
- Installation - Demo Database Setup.
Test Environment - Version 9400 Beta 4
- Databases created on QA1 and QA4 from machine 10.0.0.11
- OS - Windows 7
Test Plan | Test | Description | Status | | 1 | Create a demo database on the local machine (QA1). The system prompts upgrade click on "Yes" - Application should be successfully uploaded.
| Pass | | 2 | Create a demo database "LINKSOFTDEMOQA4" on QA4 from QA1. The system prompts upgrade click on "Yes" - Application should be successfully uploaded.
|
| | 3 | Database create message should include database name as "LINKSOFTDEMOQA4" and server 10.0.0.14
|
| | 4 | Create a demo database "LINKSOFTDEMOQA4" on QA4 from QA1. The system prompts upgrade click on "No" - Database should not upgrade
|
| | 5 | Create a new database on the local machine (QA1). The system prompts upgrade click on "Yes" - Application should be successfully uploaded
|
| | 6 | Create a demo database "LINKSOFTNEW" on QA4 from QA1. The system prompts upgrade click on "Yes" - Application should be successfully uploaded.
|
|
Thanks Rashna |
|
| 05 Jun 2018 | 03:30PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-06-2018 03:30 PM |
| Thanks Rashna |
|
| 09 Oct 2019 | 08:14AM Comment 6 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |