Upgrading the ItronEE SQL database

This section provides instructions for upgrading the IEE SQL Server database schema. For instructions on SQL Server database software installation or database upgrade, refer to the SQL Server Installation Guide for your database platform.

Caution: Back up the ItronEE database before upgrading to IEE 10.4.

If upgrading a SQL Database from SQL 2008 to SQL 2016 and above, the compatibility scripts are already included in the SQL_Create_Admin_Schema.sql script. If the ItronEE database was attached to the server at the time that the Admin database was created, then the compatibility level is correctly set and does not require further action.

If performing a new installation of the database, recurring schedules for tasks are not created by default (including tasks for BaselineGenerator, DailyCheckForBillArrival, CustomerCareHousekeeping, and HourlyNotificationScheduler). You need to create these schedules and set them to No End Date after installing and upgrading.

Upgrade the database automatically by using the IEE installation disc. Alternatively, you can upgrade the database manually by using Microsoft SQL Server Management Studio.

Caution: Back up the ItronEE database before installing the database upgrade.