These scripts are valid for version 6.2.4 or 6.3 of Mobile Asset. Patch v6.3 is a client-only update.

Backup your version 5 database first, as a precaution.

Download and extract the scripts from https://dl.waspbarcode.com/kb/ma/v6/UpgradeDbMA624.zip, then run them in the following order:

File1=UPG_Data_types.sql
File2=UPG_Tables_address.sql
File3=UPG_Tables_customer.sql
File4=UPG_Tables_manufacturer.sql
File5=UPG_Tables_phone.sql
File6=UPG_Tables_site.sql
File7=UPG_Tables_supplier.sql
File8=UPG_Tables_employee.sql
File9=UPG_Tables_location.sql
File10=UPG_Tables_item.sql
File11=UPG_Tables_asset.sql
File12=UPG_Tables_asset_class.sql
File13=UPG_Tables_label_name.sql
File14=UPG_Tables_findmeta.sql
File15=UPG_Tables_report_name.sql
File16=UPG_Tables_report_labels.sql
File17=UPG_Tables_form_field_meta.sql
File18=UPG_Tables_department.sql
File19=UPG_Tables_no_changes.sql
File20=UPG_New_Tables.sql
File21=UPG_Tables_contracts.sql
File22=UPG_Tables_users.sql
File23=UPG_Tables_Schedule.sql
File24=CreateAssetViews.sql
File25=CreateAssetStoredProc.sql
File26=CreateTriggers.sql
File27=CreateWaspConfig.sql
File28=CreateWaspAccounts.sql
File29=Install_ENGLISH_Inserts.sql

File30=SetDefaultDatabase.sql  <--- This script must be edited to put in your correct server name.

Refer to KB article "MobileAsset: V6 Enterprise database creation scripts" (linked below) if you would like to install additional databases without using the Database Manager tool.