SQL Server 2012 to SQL Server 2016 Upgrade Process

Before starting the upgrade process, the following conditions must be met to

ensure the upgrade completes without any issues. If any of these items have not

been met, do not proceed with the upgrade until they have been completed.

Failure to do so may result in data corruption or even data loss. Read this

document in its entirety before starting the upgrade process.

Pre-requisite Checks

  •  The main Amazing Charts computer must meet our minimum specifications, which are detailed here: https://amazingcharts.com/system-requirements/

  •   All Windows updates have been installed and there are no pending updates waiting to be installed

  •   The main Amazing Charts computer’s C: drive has at least 6 GB of free space

  •   You have SQL 2012 Express SP2 or higher installed

  •   You are running 64-bit SQL 2012 Express

  •   3rd Party anti-virus software has been disabled (it may be enabled again after the upgrade)

  •   All users have saved their work in Amazing Charts and closed out of the program; do not attempt to access the

    program until the upgrade has been completed

  •   A backup of the Amazing Charts database has been made and is accessible if needed

  •   If the main computer is a laptop, ensure that the charging cord has been connected

*

If you are running Amazing Charts on 32-bit SQL 2012 Express, SQL 2012 Standard or if your main

Amazing Charts computer is a domain controller, DO NOT ATTEMPT THE UPGRADE PROCESS LISTED

BELOW. The upgrade process will not work and will require an appointment with tech support to

complete the upgrade

.*

Creating a database backup

  1. On the main Amazing Charts computer, click on the Windows start button and scroll until you see the Amazing Charts folder. Open the folder and select the “Amazing Backup” program.

Screenshot 2024-09-13 at 2.29.41 PM

  1. Click on “Backup Now” to start the backup.