Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-201

Update i2b2 demo data scripts to support Microsoft SQL Server 2012

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.7.07
    • Component/s: None
    • Labels:
      None
    • Rank:
      0|i002gv:
    • Affects Database/s:
      SQL Server
    • Developer Notes:
      fix has been made in several tables and some procedures .
    • Testing Notes:
      Hide
      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.
      Show
      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.

      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)

        Attachments

          Activity

            People

            • Assignee:
              jmd86 Janice Donahoe
              Reporter:
              jmd86 Janice Donahoe
              Participant/s:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code