Applying Database Updates Manually
Every time PIESCentral starts it checks the database version to make sure it is current. If necessary (and if you have the sufficient rights), any database updates are applied automatically. If you get a message that “A database update is required.”, you have two choices.
The database update must be applied by someone with the db_owner or db_ddladmin role in the PIESCentral database. A user with
one of these roles should be able to just run PIESCentral one time and the updates will be applied automatically.
The update can also be applied manually with SQL Server Management Studio. To do that
-
Run “select * from version” to get the current version.
-
Run the update scripts in order from the current version to the latest. The scripts can be found in
c:\program files\PIESCentral\DbUpdates.
For example, the latest database version is 1.39. First run select * from version. The current version should be 1.38,
assuming the previous version was installed. Run DbVer1-39.sql to complete the update.
(If select * from version returns 1.37, you would need to run first DbVer1-38.sql and the DbVer1-39.sql).