手动升级移动资产企业数据库从任何4.0或更新版本到v5.5.1:
下载这个文件:
http://dl.waspbarcode.com/wasp/supportfiles/upgradedbma5.zip
将zip文件解压缩到一个文件夹。
***修改BackupExistingDB。sql,以便在运行文件之前为备份输入有效路径,或者在运行其余脚本之前手动创建备份。
在完整版本的SQL Server上按以下顺序运行脚本:
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
这些脚本是MobileAsset 5.5.1版本的最新版本。