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

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.7.07
    • None
    • None
    • SQL Server
    • fix has been made in several tables and some procedures .
    • 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

          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Assignee Lori Phillips [ lcp5 ]
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.07 [ 10201 ]
          lcp5 Lori Phillips made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          lcp5 Lori Phillips made changes -
          Developer Notes fix has been made in several tables and some procedures .
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Assignee Lori Phillips [ lcp5 ] Janice Donahoe [ jmd86 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          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.
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe added a comment - - edited
          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.
          jmd86 Janice Donahoe added a comment - - edited 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.
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: