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
All users need to be out of the system to prevent data loss.
Access to run this app on the server where the SQL instance is located.*
Database is at or above the minimally supported database version. (SQL 2012 at the time of this writing)
sp_RestoreDatabaseFromPath.sql
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)..Net Framework 4.7.2 or later is installed on SQL Server ( Download .NET Framework 4.8 )
A backup of the databases should be made just prior to the update.
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
Copy the installer Zip to the SQL server where the database to be updated is stored.
Run the Aeros PRODUCT.bat file to launch the UI (PRODUCT: LIVE, CONNECT, ERP)
NOTE: UNC paths ( \\SERVERNAME\c$ ) are not supported, the file needs to be launched from a local drive.
Supply the database server and name
Pro Tip: If you pre-set the values in the AerosDatabaseDeploymentTool.exe.config file, the UI will load with the fields pre-populated.
Provide the user name and password for the given SQL Server.
Press the "Test Connection" button to verify connectivity.
The status bar should display whether a connection was successful.
The tool shows what version the database will be updated to in the "Upgrade Database Version" textbox in the top right of the UI.
Pro Tip: Specific versions can be set in the Advanced Mode if not updating to the latest version.
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.
At this time you should be able to click the Upgrade Database and upgrade.
NOTE: BACKUP THE DATABASES PRIOR TO UPDGRADE
After confirming that backups have been made, the tool will run all tasks necessary to upgrade the database.
Once the process has completed, the "Current Database Version" text box should be updated to match the latest version.
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
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.
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.
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.
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.
Run Product Executable
Once you have updated the database with the updated version, you can then uninstall the application from the application servers and run the Application Executible.
Add or Remove Programs from Control Panel: Uninstall the application you wish to upgrade.
Run the .msi Installer Executable
Log in and make sure all is well.
Developer Notes: /wiki/spaces/RD/pages/34705086