Update Database New

Home / Update / Client Code

How to update the Database to the Latest Release.

Link to the original Instructions for updating the Database: [Updating the Database]

(https://github.com/CSOIreland/PxStat/wiki/Update-Database).

N.B. Before doing any update, it is recommended that you take a full backup of your database.

Updating the Database is very straight forward.

• Please supply a valid PxStat admin username. Your app config changes will be shown against this name : Additions to the config need an admin name for auditing purposes

• Please enter the database server name or ip address : This is the machine name or ip address of the server that runs the db

• Please enter the database name: The SQL Server DB name, e.g. pxstat.test

• Please enter a database user name (with at least dbo privilege). If your are using a Windows account, just press Enter to skip this. If you enter a name, you must entner a password. Otherwise it is assumed you have AD rights to the database

• Please enter the path to your database folder, e.g "C:\Development\6.0.0\db\

• Please enter the version of pxstat from which you are upgrading

• Do you wish to run a full database upgrade?

• Do you wish to create an API config from the web config?

• Please enter the path of the web.config file from which you wish to read, e.g. C:\PxStat\web.config

• Do you wish to create a Firebase Key API config entry from a Firebase.json file?

• Do you wish to create an APP config on the database?

• Getting config details. When you have finished entering configurations, just press enter and the application..

• Do you wish to update the appsettings.json file from the web.config?

• Please create a suitable Memcached salsa for this environment.

• Do you wish to create the log4Net.config from the web.config

• Do you wish to create an IIS web.config file from the web.config.

• Do you wish to run all of the json config upgrade scripts after the chosen version to the current version of the API config?

• Ensure new web.config is in the Visual Studio project.

• Ensure the new appsettings.json is in the Visual Studio project.

• Amend the appsettings.json connection string for an AD user.

• Ensure new log4net.config file is in the Visual Studio project.

• Amend the log4net.config file connection string for an AD user.

• Build the project.