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