ITD is  upgrading the SQL Server 2008 Shared database environments to SQL Server 2012 or 2014. This page outlines the process, schedule, and responsibilities of the project.

Overview

Microsoft mainstream support for SQL 2008 ended in 2014. This upgrade is necessary to remain current with supported product releases and provide new functionality required for future development.  The planned completion date of the upgrade for agency applications is December 31, 2016. Completion by this date will ensure state agencies avoid the SQL Server 2008 legacy fee and guarantee that state agency applications are running on a fully-supported version of SQL Server.  Reference ITD's Data Processing Projected Rates for 2015-2017 Biennium document for more details about billing. 

Agency Responsibilities

Each agency will be provided a spreadsheet listing their databases that are hosted in SQL Server Shared environment. Agencies will be asked to fill in the missing columns in the spreadsheet and return the spreadsheet to the Database Team. This requirement will need to be completed prior to upgrading any databases. The following spreadsheet columns will need to be completed:

  • SQL Server Instance Name
  • Database Name
  • Application Name
  • Agency Contact Person
  • Application Notes
  • Vendor Name
  • ITD Contact Person
  • Number of Users
  • Agency Acceptance Testing Time

ITD Supported Applications

The applications that are directly supported by ITD Software Development Division will need to submit an ITD Software Development Service Request requesting changes be made to their application(s).   The time required for ITD Software Development staff will include application system testing and the transferring of the application to the test and production servers and will be chargeable to the agency.  In addition, every agency will be asked to perform a functional test and sign off on the application prior to the transfer to production.

Non ITD Supported Applications

Since many of the databases are hosting vendor-provided applications, each agency will be primarily responsible for contacting the vendors to determine an upgrade plan for each application. If an agency requires assistance with this, the ITD Database personnel will be available to participate in any agency/vendor conversations.

Upgrade Process

For each application/database maintained by the Database Team, please submit two database service requests. The first service request will be for the migration of the database(s) from the SQL 2008 testing environment to the SQL 2012 or 2014 testing environment.  Each agency will also be responsible for completing acceptance testing for each of their applications. Upon completion of acceptance testing, the agency will submit a second service request for the migration to the SQL 2012 or 2014 production environment.  After production acceptance testing has been completed, the old databases will be purged from the SQL Server 2008 environment. Agencies will be given forty-eight (48) hours to complete production acceptance testing prior to the purge of their old databases.

Schedule

Each agency has been assigned to a schedule group.  Each schedule group has been assigned a time window for completion of their application migrations.

Group #1 (1/1/2016 through 3/31/2016)

  • Information Technology Department

Group #2 (4/1/2016 through 6/30/2016)

  • Department of Transportation
  • Department of Human Services
  • Department of Public Instruction
  • Job Service ND
  • Labor Commission
  • State Library
  • Highway Patrol
  • ND University System
  • Office of Administrative Hearings
  • Public Employees Retirement System
  • State Historical Society

Group #3 (7/1/2016 through 9/30/2016)

  • FileNet
  • Commerce
  • Department of Corrections and Rehabilitation
  • Department of Agriculture
  • Insurance Department

Group #4 (10/1/2016 through 12/31/2016)

  • Department of Health
  • Department of Emergency Services
  • Department of Financial Institutions
  • Bank of ND
  • Career & Technical Education
  • Game and Fish
  • Governor’s Office
  • Office of Management and Budget
  • Secretary of State
  • Tobacco Prevention Cessation & Control
  • Office of State Treasurer
  • Office of State Tax Commissioner
  • Workforce Safety & Insurance
  • Parks and Recreation
  • Office of the Attorney General
  • Securities Department
  • Retirement and Investment Office
  • Rough Riders Industries

Note: Eight hours of Database Administrator (DBA) time per database have been scheduled for the upgrades.  In the event that these eight hours are exceeded, an agency may incur hourly charges for any additional DBA time.

If you have questions or concerns, please contact Patrick Groce, Database Administrator, at (701) 328-3246 or pgroce@nd.gov.