POS hotfixes for AX for Retail 2010 R1 and R2 could include scripts to update the POS database. To upgrade the POS database, please complete the following:
1. Before installing the hotfix:
a. Make a backup of your existing store database.
b. In SQL Management Studio, view the current database version (DBversion) by running the follow SQL statement against the POS database:
select * from POSISINFO
2. After installing the hotfix:
a. Start Retail Database Utility (Start > All Programs > Microsoft Dynamics AX 2012 > Retail Database Utility > Retail Database Utility). In the configuration dialog box, enter information
into the Store database and Identification fields, and then click Continue. This will execute the script, if available, to upgrade your database.
b. In SQL Management Studio, view the current database version (DBversion) by running the follow SQL statement against the POS database and verify that the database version has changed:
select * from POSISINFO
