Winsby Group LLC Corporate Logo

Applying Database Updates Manually

Every time one of our Client/Server programs starts, it checks the database version to make sure it is current. If necessary (and if you have the sufficient rights), all database updates are applied automatically.

If you get a message that “A database update is required.”, you will need to have someone with db_owner (or db_ddladmin) rights run the client program (e.g. AceMapper, ProMapper, etc.) or have your database administrator apply the updates manually using SQL Server Management Studio (SSMS).

Manual Process

  1. Run “select * from version” to get the current database version.

  2. Run the update scripts in numerical order from the current version to the latest. The scripts can be found in

c:\Program Files (x86)\(Program Name)\DbUpdates

Where (Program Name) is AceMapper, PIESCentral, etc.

For example, suppose the latest database version is 1.39 and select * from version returns 1.38 (indicating the previous version was installed). You would Open and Execute DbVer1-39.sql in SSMS to complete the update.

(If select * from version returns 1.37, you would need to run first DbVer1-38.sql and then DbVer1-39.sql).

Revised: 2017-05-10
Next