Make a backup of the Sage 100 ERP SQL database and restore on New Server

1. Open SQL Server Management Studio
2. Log into Database Engine
3. Open Databases by click +
4. Make a backup of the MAS_System and MAS_XXX (XXX= company code)
   • Right-click each database and select Task, Backup
5. Restore the MAS_System and MAS_XXX (XXX= company code) databases on new server

Install Sage 100 ERP Premium on new server and merge system files

1. Start Sage 100 ERP Premium installation on new server
2. On the Database Server Login screen, Enter Login ID and Password and click Next
3. Message Warning The installation has detected an existing MAS_System database on 'SQLServerName'
   Click Ok to merge your new system files with this database, or click Cancel to select a different SQL server. Click OK to merge new installation with the restored MAS_System database.

Setup Sage 100 ERP Premium service for new installation

1. Open Sage 100 ERP Application Server Configuration
2. Click Server tab
3. Enter desired Port and uncheck Keep Alives
4. Click Apply then Exit
5. Open Application Server Service Setup click OK
6. Open Windows Service console
7. Select Sage 100 Premium ERP (XXXX) service (XXXX=Port)
8. Click Log On tab and enter Account information. Note: This account should be a Domain account, with local Administrator privileges, and sufficient permissions to all Sage 100 ERP resources.
9. Click Apply and Start service

Copy MAS90 directory from old server to new server

1. Have all users exit Sage 100 ERP
2. On old server open Windows Service console and Stop the Sage 100 ERP Premium and Sage 100 ERP Integration Engine services
3. Copy the ..\MAS90\ folder from the old server to the new server temporary location

Run Pre-migration to backup source data

1. Log into Sage 100 ERP
2. Open Library Master, Utilities, Pre-Migration
3. Enter the UNC path to the source installation (i.e. \\servername\sharename\..\MAS90)
4. Click Proceed

Run Parallel Migration Utility

1. On the new server stop the Sage 100 ERP Premium and Sage 100 ERP Integration Engine services
2. Make a backup of the ..\MAS90 folder of the new installation
3. Browse to the new installation ..\MAS90\Migration\ folder
4. Open Migrate.exe and Click Next
5. Select Sage 100 ERP Premium radio button
6. Check the Above steps have been performed check box. Click Next
7. Enter Database Server Login information of the Target SQL Server. Click Next
8. Enter the password for the new Sage 100 ERP Premium installation. Click Next
9. Enter the UNC path to the Source installation ..\MAS90\folder. Click Next
10. Enter the Database Server Login information of Source SQL Server. Click Next
11. Enter the password for Sage 100 ERP Premium Source installation. Click Next twice
12. Select Yes on the Migrate Companies screen. Click Next
13. Select Companies to migrate from source installation
    Note: Exist appears next to the company name because the company code exist in the SY_Company table. However the MAS_XXX (XXX=Company Code) folder does not exist under the destination ..\MAS90\ directory. You will need to select the companies you want to migrate from source company.
    

1. Click Next twice to start Migration