这些脚本适用于版本6.2.4或6.3的移动资产。Patch v6.3是一个仅针对客户端的更新。
首先备份你的版本5数据库,以防万一。
下载并提取脚本http://dl.waspbarcode.com/kb/ma/v6/UpgradeDbMA624.zip,然后按以下顺序运行它们:
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 <——必须编辑此脚本,以放入正确的服务器名。
如果您想在不使用数据库管理器工具的情况下安装额外的数据库,请参阅KB文章“MobileAsset: V6企业数据库创建脚本”(链接如下)。