Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Discontinued Products
  • Mobile Asset v6 and older
  • MobileAsset v5: Enterprise database upgrade scripts
Subscribe Download PDF

MobileAsset v5: Enterprise database upgrade scripts

Internal User
2023-01-19
in Mobile Asset v6 and older

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.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

4 of 17 people found this page helpful


Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro