To Update the Database and Site of an MYOB Advanced Instance

After you have updated the MYOB Advanced Tools, you need to update the database and the site of your MYOB Advanced instance. For an overview of the update procedure, see Updating MYOB Advanced by Using the Configuration Wizard.

To Update the Database and Site of an MYOB Advanced Instance

  1. Run the MYOB Advanced Configuration Wizard on the server where the MYOB Advanced Tools are installed.
  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 version you want to update. You can see the current versions in the Site Version and DB Version boxes.
    2. Click Upgrade.
  4. When you're prompted, click Yes to continue the update.
  5. In the SQL Server Authentication dialog box, do the following:
    1. Select the authentication method to be used to connect to the database.
    2. If you have selected the SQL Server Authentication option, specify an account that has sufficient rights to make changes to the database.
    3. If you want to shrink data after the database maintenance, select the Shrink data check box.
    4. Click OK to start the update.

For instances that contain published customization projects, the system first validates the compatibility of the currently published customization code with the code of the selected product version. If the validation is successful, the system updates the database and the site. If the validation fails, the Validation Failed window opens to display the list of the executed checks and the discovered errors, and the update process is interrupted. To resolve any issues that were discovered, see To Resolve an Issue Discovered During the Validation.

The time required for the update depends on the performance of your database server, the differences between the old and current versions of the database schema, the hardware configuration of the server, and the current system load. When the update of the instance is finished, the MYOB Advanced Configuration Wizard updates the list of instances.

Also, we strongly recommend rebuilding search indexes by using the Rebuild Full-Text Entity Index (SM209500) form.