Upgrading SQL Express to Full SQL

Installing

The fast and easy Quick Install option automatically
installs a size-limited SQL Server Express database useful for evaluation.
When upgrading from Veriato Recon/360
version 8.5 to 9.x, a Quick Install migrates only one STORAGE database.
The good news is, any time following your installation of Veriato
Recon/360 with SQL Express, you can upgrade the Express installation
to SQL Server Standard or Enterprise. The SQL Server upgrade automatically
converts your size-limited Veriato Express database to a full SQL
instance that expands and allows you to
import version 8.5 archives.  

NOTE: You will
be “installing over” your existing SQL Server Express installation.
Make sure the current computer meets requirements
for MS SQL Server and for the number of client Recorders you plan
to deploy.

Preparation

1. First, install Veriato Recon/360
   using the Quick Install option
   or using Install with Options
   and do NOT select an existing SQL Server database. Either approach
   installs MS SQL Server Express 2016.  
2. Acquire SQL Server Standard 2016 or Enterprise
   2016 from Microsoft.

Install Steps

1. At any time following installation, copy your
   SQL Server installation package to the Veriato Recon/360
   computer.
2. Run the SQL Server installer to upgrade the SQL
   Server Express edition. At the opening installation panel, select

   Maintenance | Edition Upgrade

   .
   

3. Enter the product key for your purchased full
   SQL Server 2016 and click

   Next

   .
   

4. Accept the license terms and click

   Next

   .
   

5. The installer should find and display the Veriato
   SQL Server Express instance on this machine. Click

   Next

   .
   

6.  At the “Ready to upgrade edition”
   panel, click

   Upgrade

   .
   

7. A summary of component upgrades shows the completed
   upgrade. Click

   Close

   . You now are operating
   with full SQL Server instead of SQL Server Express.
   

Updated 04/22/19