CDR Tickets

Issue Number 4327
Summary Upgrade to SQL Server 2016
Created 2017-10-18 17:05:58
Issue Type Improvement
Submitted By Kline, Bob (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2017-12-05 09:40:18
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.215769
Description

CBIIT has issued a mandate that we move to SQL Server by the end of this calendar year. We need to make some changes to some of the stored procedures and views which run afoul of the new version's requirements.

Comment entered 2017-12-05 09:40:18 by Kline, Bob (NIH/NCI) [C]

Files created/updated for this ticket:

M Database/procs.sql
A Database/sql-server-2016-upgrade.py
M Database/tables.sql

Commits:

https://github.com/NCIOCPL/cdr-server/commit/8870b0c2
https://github.com/NCIOCPL/cdr-server/commit/21af12f8

These have been applied to DEV and QA.

Comment entered 2018-01-29 12:53:40 by Englisch, Volker (NIH/NCI) [C]

, SQL Server has been upgraded on STAGE and PROD. I believe this ticket can be closed, right?

Elapsed: 0:00:00.001345