To manually upgrade a Mobile Asset Enterprise database from any version 4.0 or newer to v5.5.1:
Download this file:
https://dl.waspbarcode.com/wasp/supportfiles/upgradedbma5.zip
Extract the zip file to a folder.
*** Either modify BackupExistingDB.sql to enter a valid path for your backup before running the file, or create a backup manually prior to running the rest of the scripts.
Run the scripts on the full version SQL Server in this order:
File1=BackupExistingDB.sql
File2=UPG_Data_types.sql
File3=UPG_Tables_address.sql
File4=UPG_Tables_customer.sql
File5=UPG_Tables_manufacturer.sql
File6=UPG_Tables_phone.sql
File7=UPG_Tables_site.sql
File8=UPG_Tables_supplier.sql
File9=UPG_Tables_employee.sql
File10=UPG_Tables_location.sql
File11=UPG_Tables_item.sql
File12=UPG_Tables_asset.sql
File13=UPG_Tables_asset_class.sql
File14=UPG_Tables_label_name.sql
File15=UPG_Tables_findmeta.sql
File16=UPG_Tables_no_changes.sql
File17=UPG_New_Tables.sql
File18=UPG_Views_Delete_all.sql
File19=CreateAssetViews.sql
File20=UPG_StoredProcs_Delete_all.sql
File21=CreateAssetStoredProc.sql
File22=CreateTriggers.sql
File23=CreateWaspAccounts.sql
File24=UPG_Default_Inserts.sql
These scripts are current for MobileAsset version 5.5.1.