SQL Server 2008 Migration to 2017

62 %

Status

Project is 62 % complete, starting on Fri 4/5/19 and ending on Thu 12/31/20.

In Process [In Process]

62% complete, updated on Mon 8/31/20 1:17 PM by Janee Franklin (franklij)

Changed Percent Complete from 60% to 62%.
DocFinity will be upgraded first then migrated. David will finalize the Final Migration List. Once this is completed we will discuss a timeline and resources. UAT will be updated based on Final Migration List. A communication plan will be created for the necessary faculty members.


We will keep Workday Team updated on the Final Migration tasks and timeline.

Details

Dates
Fri 4/5/19 - Thu 12/31/20
Acct/Dept
Information Technology
Service
Technology Projects, Ideas, Proposals & Business Cases / Project Request
Type
Projects / General Project Request
Health
Green - On track
Portfolio(s)
Classification
Run
Requirements
Build new SQL 2017 test and prod servers and migrate application databases like for like to the new server cluster. Identify and eliminate any applications that are no longer being utilize. Decommission SQL 2008 server cluster.
Created
Wed 4/3/19 4:25 PM
Modified
Mon 8/31/20 1:17 PM
Is this in response to regulatory compliance?
No
Does the project involve software that will store employee data on the Internet/Cloud?
No
Does the project involve software that will store student data on the Internet/Cloud?
No
Risk of doing nothing:
Describe the impact to the business if this project is not selected for implementation.
Both the SQL and Windows versions that the cluster is currently using will be completely unsupported by Microsoft.
Has this project been funded?
Yes
Who will sponsor this project?
Whoever "owns" the project on behalf of the organization. The person that has overall responsibility for a project and can authorize work on the project to begin. The VP with funding authority who has provisioned funds for the project.
Chief Information Officer
Will there be vendor engagement?
Will any vendor be contracted to perform any work on this project?
No
Hardware One-Time Cost
0
Hardware Annual Cost
0
Hardware Supporting Information
NA
Software Lisences One-Time Cost
0
Software Licenses Annual Cost
0
Software Licenses Supporting Information
We will be using our current SQL licenses to fully license the VmWare ESX hosts that the new cluster will reside on.
Contractors One-Time Cost
0
Contractors Annual Cost
0
Contractors Supporting Information
NA
Total One-Time Cost
Specify low and high end range, as applicable, for 90% certainty.
0
Total Annual Cost
Specify low and high end range, as applicable, for 90% certainty.
0

Description

SQL 2008 End of Life (EOL) is in July and Windows 2008 EOL is in Jan 2020, therefore, a new SQL cluster is required. All of the current databases on the production cluster must be relocated to either a new SQL cluster or separate SQL servers depending on their nature.

Goals

  1. EXCEL - Escalate Continuous Improvement

    It allows us to improve the data storage infrastructure.

Risks

  1. Low Unknown Technology Complexity

    Unknown compatibility issues with newer version of SQL

Stakeholders (8)

AC

Andrew Cronkhite (cronkhia)

Application Support Services D
Informed
Applications Director
Tue 4/2/19 4:09 PM
Anthony Perrone (perronea)

Anthony Perrone (perronea)

Director of Project Management
Informed
PMO
Tue 4/2/19 4:07 PM
DB

David Bunnell (bunnelld)

Database Administrator II
Responsible
Requester
Tue 4/2/19 4:08 PM
DE

David Edris (edrisd)

IT Customer Support and Qualit
Informed
Informed
Wed 4/3/19 4:31 PM
ER

Edith Robinson-Johnson (robinsoe)

Quality and Customer Services
Informed
Informed
Wed 4/3/19 4:31 PM
GA

Guy Albertini (albertig)

Information Security Officer
Informed
Informed
Wed 4/3/19 4:30 PM
KL

Ken Libutti (libuttik)

Chief Information Officer
Responsible
Sponsor
Tue 4/2/19 4:07 PM
MS

Marissa Steinberg (cohenm2)

Temporary Project Manager
Informed
Governance
Tue 4/2/19 4:06 PM