If you need to manually create the MobileAsset database on an existing server by running SQL scripts rather than running the installation executable:
1. Download and extract the script files from https://dl.waspbarcode.com/wasp/supportfiles/InstallNewDbAsset624.zip then follow these steps:
2. Edit this file to replace SERVERNAME with your correct server (or server\instance):
File9=SetDefaultDatabase.sql
3. Run these scripts in the following order to install the default database:
File1=CreateWaspConfig.sql
File2=CreateAssetDataTypes.sql
File3=CreateAssetTables.sql
File4=CreateAssetViews.sql
File5=CreateAssetStoredProc.sql
File6=CreateTriggers.sql
File7=CreateWaspAccounts.sql
File8=Install_ENGLISH_Inserts.sql
File9=SetDefaultDatabase.sql
4. For customers with the Enterprise edition who need to create additional company databases via script:
Edit each script file in Notepad (or other text editor) and replace all instances of WaspTrackAsset with WaspTrackAsset_<NAME>, where <NAME> is the name of the database in SQL.
In SetDefaultDatabase.sql, you will also need to replace Default Company with the company name for the new database.
---------------------------------------------
These files are current for MobileAsset application version 6.2.4 or 6.3 (database version 6.2.1).