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.
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.
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:
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.
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.
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)
Group #2 (4/1/2016 through 6/30/2016)
Group #3 (7/1/2016 through 9/30/2016)
Group #4 (10/1/2016 through 12/31/2016)
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 firstname.lastname@example.org.
Hosting is running and maintaining a computer system or application on someone's behalf; typically within a modern datacenter.
ITD operates dedicated equipment necessary to host agencies database applications.