Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5
div
idrnwid

Article ID: 36232

HTML
<!--Product families-->
<div style="display: none;" data-swiftype-name="productFamily" data-swiftype-type="enum">Accountants Office Suite</div>
<!--Countries-->
<div style="display: none;" data-swiftype-name="country" data-swiftype-type="enum">New Zealand</div>
<!--Product capabilities-->
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AO Tax (NZ)</div> 
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AO Practice Manager (NZ)</div>
div
idrnwdate

ARTICLE LAST UPDATED: 6/06/2017 1:01:00 PM

div
classinternalnote

MYOB INTERNAL STAFF ONLY

**DO NOT MODIFY THIS ARTICLE. WHERE CHANGES ARE REQUIRED, REFER TO THE TECHNICAL SERVICES TEAM**

This article will advise you how to migrate MYOB Accountants Office (AO) and AO Classic by backing up the databases, installing AO classic, applying any applicable updates, installing SQL, installing AO 2013.0 or greater without converting data, restoring the database and then running a repair.

Please read through the instructions below prior to undertaking the migration process. MYOB strongly suggests that the migration of MYOB AO is performed by an individual with strong knowledge of these software products and is competent with the Microsoft Windows operating system. If you experience issues with MYOB software after following the instructions below, additional assistance of your migration may fall outside of the terms of your Sales and Service Agreement.

MYOB provides a Migration Service. If you have any doubts or concerns about completing this migration yourself, please contact your MYOB Client Manager and arrange for one of our technical services analysts to perform the migration for you. This service may require a booking, so please plan well in advance.

UI Text Box
sizemedium
typeinfo

Before you install MYOB AO, consult the System Requirements page to ensure your setup is adequate to continue. Please talk with your IT provider if you have any questions.

UI Expand
titlePre-migration checks
  • Ensure you are logged in as an administrator user.
  • Ensure User Account Control (UAC) is switched off. For more details refer to KB 30854: Disabling User Account Control (UAC)
  • Ensure Data Execution Prevention (DEP) is set to the default setting. For more details refer to KB 34263: Establishing Data Execution Prevention (DEP) settings
  • Ensure any Anti-Virus, Anti-Spyware, Anti-Malware, Firewall or any other such security software is switched off.
  • Ensure Linked Connections are enabled on any Server 2012 and/or Windows 8 machines. For more details refer to KB 35152: Enabling Linked Connections in Windows
  • The Date and time, language and regional settings are set to the correct region and time.
  • .Net Framework 3.5 to 4.6 are enabled/installed.
    • Server 2016: via Server Manager
    • Server 2012: via Server Manager for 3.5 & 4.5, while 4.6 is a manual install.
  • The drive that will be hosting the MYOB data is less than 1.8TB in partition size.
  • Check what MYOB AO products you are licenced for on your current server. and you're installing the same version of MYOB AO that is currently installed on your existing server.

Please confer with your IT professional if you have any issues with the above.

UI Expand
title1. Backup the MYOB AO data on old server/standalone
  1. Open MYOB AO. MYOB AO opens.
  2. Follow the menu path: Maintenance > Backup > Back Up Now. The Backup up now window appears.
  3. Provide a location and name then click Back up. The backup has completed successfully prompt appears.
  4. Click OK. You have successfully backed up your Tax and Practice Manager data.
  5. Also backup AODB1 SQL databases using SQL Management. For more information, refer to KB 33978: Backing up a SQL database using Management Studio
  6. Backup templates and client documents – see topic below
  7. Backup MYOBAO folder
  8. Document Manager ( if using Documet Manager) : Backup Document Manager and Intranet File Stores.
    For more details refer to KB 23595: What files do I need to backup for MYOB Document Manager?. Please note All documents must be checked in prior to copying data. For details refer to KB 23570: How do I view a list of all checked out documents?
  9. Take these backed up files off the server onto either the new server or a device to copy it over to the new server, such as a USB stick.
UI Expand
titleLocating my templates and documents

Locating your templates and documents

In MYOB AO navigate to the Maintenance menu > Maintenance Map > Documents. Note down any relevant paths under the following areas:

Document settingsNote this path
Document Creation Settings
  • Tax Receipts Algorithm
  • VAT Receipts Algorithm
  • Word Billing Algorithm
Mailing Settings
  • Billing Startup Path
  • Templates Path
  • Document Startup Path
Document Styles
  • All selected styles

If these paths are still in use and you're unsure what these paths are for, refer to the help menu. Make sure the files in these locations are copied across to the new server.

UI Expand
title2. Pre-configuration and MYOBAO Data copy

Standalone install pre-configuration

  • Create MYOBAO folder on C:\ drive
  • Copy the data folder from old PC into C:\MYOBAO\ folder.
    Rename the AOSQL to AOSQL.old folder within the MYOBAO folder.

Network install pre-configuration

  • Create the AONET directory to store MYOB AO program and data files. This can be located anywhere on the server machine. You will need to refer the installer to this location later.
  • AONET must then be shared and mapped as a network drive on the server and all workstations.
  • You will also need to copy MYOBAO folder to the AONET folder. Inside MYOBAO folder, rename AOSQL folder to old. 
UI Expand
title3. Copy Document Manager and Intranet File Stores (if using Document Manager)

Document Manager

Intranet File Store

  • The Intranet File Store folders must be copied to the default location M:\MYOBAO\AOSQL\Knowledge Management\Intranet\Data (Where M:\ is the mapped drive for AONET share). You will have to first manually the create folders for Knowledge Management\Intranet\Data under the AOSQL folder.

If you copy over the Databaselookup.XML file that exists in both your DMFS and Intranet Data folder, you'll need to delete both XML files before you run the installer. If you have multiple MYOB AO databases, you may also have multiple file stores. Ensure these are brought across as well. For example, DMFS_AODB1, DMFS_AODB2

UI Expand
title4. Install AO Classic onto the new server

For more details on transferring data and installing AO Classic, refer to KB 36231: Migrating Accountants Office Classic to a new standalone or server machine? (AO Classic NZ).

Ensure you download and install any and all relevant versions before installing MYOB AO.

UI Expand
title5. Install Accountants Office 2013.0 or later on the new server

Check what release version of MYOB AO is installed on the old server and download that version from my.myob.com.au. When the download is complete, install that version of MYOB AO.

UI Text Box
typewarning
If you have copied the MYOBAO folder from the old machine to the new machine as part of a network install of AO Classic, please ensure you rename the AOSQL\Registration folder to Registration.old. If you fail to do this, you will receive an error "License not valid for this computer" when using AO. To resolve, you will need to reinstall and redo the migration.
  1. Download the MYOB AO full release from Product Downloads page then launch the MYOB AO install. The Welcome window appears.
  2. Select the An existing MYOB AO user? option and click Next. The wizard continues and the Before you install step appears.
  3. Read the Upgrade Guide, and click Next. The wizard continues and the Install MYOB AO step appears.
  4. Click the link to install MYOB AO. The MYOB AO Installation Wizard opens.
  5. Select the Accept the License Agreement option and click Next. The wizard continues.  The installer does a system check to ensure that your system meets the necessary requirements, and if OK, takes you to the Setup type selection.
  6. Select Network or Standalone, as applicable and click Next. The wizard continues.
  7. Select Standard Install or Custom Install (recommended) and click Next. Database conversation window appears, and it shows current AO Classic data location, ensure the location of Classic data is correct and click Next.
  8. Untick “Backup this AO Classic database” and Tick “I don’t have any data to convert”. If Custom Install option was selected, it will allow to change the location of MYOBAO folder, for network install point it to the path created earlier e.g. M:\MYOBAO where M is the mapped drive for AONET
  9. Database: the installer will attempt to detect an existing AO Classic data folder to convert. Ensure the location of Classic data is correct and click Next. The wizard continues.
  10. Select your applicable products, click Register (recommended), and contact MYOB Support on 0800 94 96 98.  Select Option 1 (Licensing) to obtain the Registration Code. The registration code is obtained.

    UI Text Box
    typenote
    If you are installing outside of Support hours, then click Temporary to complete the registration at another time. This will allow ONE user access for only 7 days until you register.
  11. Enter a valid Registration Code for the displayed serial number & Number of users. The message "You have registered the following products successfully" appears.
  12. Click Close. The registration process is complete. A summary of the install details is displayed, showing the target folder for MYOB AO 2013.0 program files; the source AO Classic database folder to be converted; and the product to be installed.
  13. Click Install Now. The required software components are now installed. This takes between 30 minutes to 1 hour, but may take longer depending on the machine, and may require the computer to be restarted one or more times. At the end of the installation, a message about Open File warnings appears.
  14. Click OK. The installation is complete.
UI Expand
title6. Restore MYOB AO backup

At this point SQL needs to get restored from the backups created earlier. For details refer tor KB 34002: Restoring an SQL database using SQL Server Management Studio.

The databases you need to restore are as follows:

  • MYOB AO: Restore AODB1 database
UI Expand
title7. Repair MYOB AO

Running the Repair will reconfigure any invalid references relating to the old server.

  1. Launch the MYOB AO installation install again. The Welcome window appears.
  2. Select the first option, An existing MYOB AO user? and click Next. The Before you install window appears.
  3. Read the Upgrade Guide, and click Next. The Install MYOB AO window apears.
  4. Click the link to install MYOB AO. The MYOB AO Installation Wizard opens. The wizard detects that MYOB AO is currently installed, and so presents different options:
    1. Convert an MYOB AO Classic database;
    2. Repair;
    3. Uninstall.
  5. Select Repair, and click Next. The installer does a system check to ensure that your system meets the necessary requirements, and     if OK, takes you to the next step, Ready to Repair.
  6. Click Repair. The installer runs through checking and reinstalling all required software and components. This may take around 1 hour.
  7. Click Finish.
UI Expand
title78. Other Configurations
UI Expand
title89. Copy MYOB AO templates and documents
  1. Copy across the templates, styles and documents copied from the old server into the MYOBAO\AOSQL folder on your new server.
  2. Open MYOB AO and follow the menu path: Maintenance > Maintenance Map > Documents section.
  3. Ensure all the paths correctly match the locations on the new server. If required, change these paths in the software to match the files' location.
UI Expand
title910. Disable SQL and MYOB Share on the old server

Disable the following services from the old server so the users don't access the data from the old server.

  • SQL Server(MYOBACCT)
  • MYOB OntheGo Service
  • MYOB Sync Client Service
  • MYOB DM Portal Sync Service (if exists)

To disable the services:

  1. On the old server, go to Control Panel > Services.
  2. Right click the service you want to disable, for example SQL Server(MYOBACCT) and select Properties.
  3. At Startup type, select Disabled from the drop-down.
  4. At Service status, click Stop.
  5. Click OK.

You'll also need to remove the share from the shared MYOB folder (for example MYOBAO). Talk to your IT on how to remove sharing from a folder.

UI Text Box
typeinfo

If you're unable to disable the SQL Server, detach the old MYOB AO database (for example, AODB1) and Tax database (for example, AOTAX1)

UI Expand
titleFinal setup process

Apply any further updates required, then proceed to do the below only if you are a network setup:

  • AO Classic: Re-run the AO Classic workstation install from the new server by running SETUP.EXE in the MYOBAO folder, eg. M:\MYOBAO\SETUP.EXE.
  • MYOB AO: Uninstall the existing AO workstation setup from Control Panel > Programs & Features, if it exists, and re-install it from the new server by running SETUP.EXE in the MYOBAO\AOSQL\WorkstationInstall folder, for example M:\MYOBAO\AOSQL\WorkstationInstall\SETUP.EXE
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
div
idid
 
div
iddate
 
div
idproductlist