To Update the Database of an MYOB Advanced Instance

You update the databases after you update the MYOB Advanced Tools.

Note: You must update the application instances as well.

To Update the Database of an Application Instance

  1. Run the MYOB Advanced Configuration Wizard on the server where MYOB Advanced is installed. For example, select Start > MYOB Advanced > MYOB Advanced.
  2. On the Welcome page, click Perform Application Maintenance.
  3. On the Application Maintenance page, do the following:
    1. In the Installed Sites list, click the MYOB Advanced instance whose database you want to update. You can see the current version in the DB Version box.
    2. In the drop-down menu next to the Upgrade button, select Update only Database.
  4. When you are prompted, click Yes to continue the update.
  5. In the SQL Server Authentication dialog box, specify the authentication method to be used to connect to the database.

    If you select the SQL Server Authentication option, specify an account that has sufficient rights to make changes to the databases.

  6. If you want to shrink data after the database maintenance, select the Shrink data check box.
  7. Click OK.

The time required for the update depends upon your database server performance and the differences between the old and current versions of the database schema.

After you have updated the database you should update the site, as described in To Update the Site of an MYOB Advanced Instance. Also, we strongly recommend rebuilding search indexes by using the Rebuild Full-Text Entity Index (SM209500) form.