[CORE-201] Update i2b2 demo data scripts to support Microsoft SQL Server 2012 Created: 18/Dec/15  Updated: 25/Jan/16  Resolved: 29/Dec/15

Status: Closed
Project: i2b2 Core Software
Component/s: None
Affects Version/s: None
Fix Version/s: 1.7.07

Type: Improvement Priority: Major
Reporter: Janice Donahoe Assignee: Janice Donahoe
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i002gv:
Affects Database/s:
SQL Server
Developer Notes: fix has been made in several tables and some procedures .
Testing Notes: TESTING STATUS: Completed (PassedTesting)
COMPLETION DATE: 12/29/2015

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

TEST DATE: 12/29/2015
TESTED BY: Janice Donahoe
BUILD NUMBER: 1.7.07.0008
TEST STATUS: Completed (Passed Testing)


CLIENTS TESTED:
     Not applicable for this test.

ENVIRONMENTS TESTED:
     Browsers: Not applicable for this test
     Databases: SQL Server 2008, 2012, & 2014
     Client OS: Not applicable for this test


TEST COMMENTS:
This was tested with the latest Web Client build (1.7.07.0008) and it appears to be working correctly. No issues were found while testing.


SCENARIOS TESTED
Verified the i2b2 demo data scripts for SQL Server ran correctly and the data was imported correctly. The scripts were run from Bamboo and verified the bamboo tests ran correctly.


ISSUES FOUND:
No issues were found during this test.
Participant/s:

 Description   
The installation scripts for the i2b2 demo data need to be updated to support Microsoft SQL Server 2012.

TEXT is no longer supported; change to VARCHAR(MAX)

 Comments   
Comment by Janice Donahoe [ 25/Jan/16 ]
On 01/22/2016, the 1.7.07 Release was made available at the following locations.

https://www.i2b2.org/software/
 - zip files for release 1.7.07 are available on this site. This includes both the code and documentation.

https://github.com/i2b2
 - source code has been tagged with v1.7.07.
Generated at Fri Jun 05 15:52:50 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.