Page Comparison

This guide explains the steps and configurations to utilize the Aeros database installer. This tool upgrades a database without needing to run SQL scripts directly in SQL Management Studio.

Pre-Requisites

1. All users need to be out of the system to prevent data loss.
2. Access to run this app on the server where the SQL instance is located.* 
3. Database is at or above the minimally supported database version. (SQL 2012 at the time of this writing)
4. sp_RestoreDatabaseFromPath.sql^{Image Modified} needs to be installed in SQL's Master database (this stored proc can be found in Deployment Tool folder and should be ran against the Master- only needs to be ran once).
5. .Net Framework 4.7.2 or later is installed on SQL Server ( Download .NET Framework 4.8 )  
6. A backup of the databases should be made just prior to the update.
7. For CONNECT and LIVE, the deployment tool needs to run off the SQL server machine.  This is because the deployment tool needs to copy the system database to the backup folder and thereafter the stored procedure sp_RestoreDatabaseFromPath will pick up the system database from there.

Running Aeros Database Installer Tool

...

NOTE: UNC paths ( \\SERVERNAME\c$ ) are not supported, the file needs to be launched from a local drive.

1. Supply the database server and name
   1. Pro Tip: If you pre-set the values in the AerosDatabaseDeploymentTool.exe.config file, the UI will load with the fields pre-populated.
2. Provide the user name and password for the given SQL Server.
3. Press the "Test Connection" button to verify connectivity.
   1. The status bar should display whether a connection was successful.

1. The tool shows what version the database will be updated to in the "Upgrade Database Version" textbox in the top right of the UI.
   1. Pro Tip: Specific versions can be set in the Advanced Mode if not updating to the latest version.
2. If a successful database connection is made, the current version of the database will be displayed in the "Current Database Version" textbox in the top right.
3. At this time you should be able to click the Upgrade Database and upgrade.
   1. NOTE: BACKUP THE DATABASES PRIOR TO UPDGRADE 
4. After confirming that backups have been made, the tool will run all tasks necessary to upgrade the database.
5. Once the process has completed, the "Current Database Version" text box should be updated to match the latest version.
   1. If this is not the case then something went wrong and you should review the output and probably restore your backups for developer review.

Advanced/Debug Mode

1. If a specific version is desired, the "Debug" app setting in the AerosDatabaseDeploymentTool.exe.config can be updated to "true" and some additional features will become available. 
2. In this mode, the user can choose which version to update the database to or choose to run each script one-by-one to assist in debugging.
3. To accomplish this, choose the desired database version in the "SQL Script" drop down and then click the "Upgrade Database" button. This operation will run all scripts between the current database version up to the desired version.
   1. This operation cannot be undone, so a backup of the database is still required!

Note: Advanced mode for Aeros LIVE and Aeros CONNECT requires the path for the specific _System database that needs to be restored for the version that is being updated to.

4. To skip system database restore, set the app.config flag SkipSystemDatabaseRestore to true.  It's up to the user to manually restore the system database before running the upgrade from the deployment tool.

...