Upgrading SQL Server 2012 to SQL Server 2019

This article details how to upgrade from SQL Server 2012 to SQL Server 2019.

Upgrading From SQL Server 2012 to SQL Server 2019

SQL Auto Installers

Uninstall SQL 2012

1. 1. Download the above SQL Auto Installers folder and extract the zip.  Copy the 04 SQL Upgrade Files to the Root of your C drive.
   2. Right click the Windows Start button > Select Apps and Features > Confirm both "XOS Thunder" and "Catapult Thunder" do not show up in the app list. If either of them do then uninstall it.
   3. Go to your C drive and open the "04 SQL Upgrade Files" folder that you copied over in step 1. Open the "SQL 2012 Auto Uninstaller" folder > Open the "Uninstall" folder > Right click Run as Administrator on the "SQL 2012 Uninstall" batch file.
      1. This will open a black cmd prompt window. Leave this window up until you see a prompt that says "Press any key to continue". At this point you can press any key and it will close the window.
      2. Reboot the machine
      3. Right click the Windows Start button > Select Apps and Features > Search for "SQL" in the "Search this list" section > confirm there are no SQL components listed > If some still exist then run the "SQL 2012 Uninstall" batch file again. Once it finishes running check Apps and Features a second time to see if anything is still listed for SQL. Select any SQL components that still show up in the list and click uninstall. Once the list is empty of all SQL components reboot the machine and then continue to the install step.

Install SQL 2019

1. 1. Go to your C drive and open the "04 SQL Upgrade Files" folder that you copied over in step 1 of the Uninstall section. Open the "SQL 2019 Installer" folder > Right click Run as Administrator on the "~SQL 2019 Installer" command script.
      1. This will open a black cmd prompt window. Leave this window up until you see a prompt that says "Press any key to continue". At this point you can press any key and it will close the window.
   2. You are now good to install Thunder 22 or later