This support note applies to:
- AO Practice Manager (NZ)
- AO Practice Manager (AU)
- AO Tax (AU)
- AO Tax (NZ)
- AO Statutory Reporter (NZ)
- AO Document Manager (NZ)
- AO Document Manager (AU)
- AE Practice Manager (NZ)
- AE Practice Manager (AU)
- AE Tax Series 6 & 8 (AU)
- AE Tax (AU)
- AE Tax (NZ)
- AE Tax Manager (NZ)
- AE Statutory Reporter (NZ)
- AE Statutory Reporter (AU)
- AE Document Manager (NZ)
- AE Document Manager (AU)
- Workpapers (NZ)
You may need to run SQL scripts when requested by MYOB Support or required by another knowledge base article to update data within the MYOB SQL databases.
The following steps will show you how to run scripts using SQL Server 20xx where 20xx represents the version of SQL that you currently have installed/configured for MYOB.
You can run a script either:
- from a file or
- manually typing the commands into SQL Management studio
- Follow the menu path: Start > Programs > Microsoft SQL Server 20xx > SQL Server Management Studio.
- In Connect to Server window, select Database Engine in the Server type field then enter the relevant details in the Server name field.
- In the Authentication, select SQL Server Authentication.
- Type sa in the Login field, then type the password in the Password field. Call Support if you don't know the password.
- Click Connect.
Use the following instructions only if you have a script provided to you in a file.
- From SQL Server Management Studio, follow the menu path: File > Open > File.
- From the Open File screen, navigate to and select the script file then click Open.
- Select the relevant database from the Available databases drop-down list.
- Press F5 or click Execute.
Perform the following instructions only if you do not have a file containing the required script.
- Click New Query. The SQLQuery tab opens in the right-hand pane.
- Select the relevant database from the Available databases field.
- Type or paste the sql query in the right-hand pane and press F5 or click Execute.