Connect to the licensed store database and force install tables

This topic describes how to connect to the licensed store database and update the tables in the store database using the Force Install Tables function.

You can run Force Install Tables as an executable in Command Prompt or PowerShell. This allows you to update or repair the store database without opening Store Administrator or Store Manager. Refer to Run Force Install Tables as an executable for more information.

1. In Store Administrator, connect to the licensed store database. Refer to Connect to SQL Server and the store database for more information.

2. In the Database pane, click Force Install Tables.

Starting with release 3.11.14, the Force Install Tables function will no longer create the SYNCGUID column in the RMH or third party app tables. The Prepare Database function will create the SYNCGUID column in the RMH table, but it will no longer create it in third party app tables.

1. Click Yes to continue.

1. Wait while Store Administrator executes the SQL scripts to create RMH custom tables in the store database. This may take a few minutes.

2. Click OK to close the confirmation dialog.