Skip to main content

MobileAsset: How to move the Mobile Asset v6 Enterprise database to a new server - Knowledgebase / Discontinued Products / Mobile Asset v6 and older / Mobile Asset v6 - Wasp Helpdesk

MobileAsset: How to move the Mobile Asset v6 Enterprise database to a new server

Authors list

Create a backup of the WaspTrackAsset database. If you have created additional company databases, create backups of them as well.

Run the installer to create the blank database. If you have additional company databases, or if you would prefer to run scripts to manually create the blank database, refer to KB article "MobileAsset: V6 Enterprise database creation scripts" (linked below) for those processes.

After creating the blank database(s), restore your backup over it/them.

In most cases, you will then need to extract the linked scripts (below) and then run the CreateWaspAccounts.sql script to update the SQL user accounts. If you have additional databases, edit the Trial_CreateWaspAccounts.sql and replace Trial in all four instances of WaspTrackAsset_Trial with your database name, then run it.

https://dl.waspbarcode.com/kb/ma/v6/MAv6-migrate-cwa-scripts.zip

Helpful Unhelpful

9 of 13 people found this page helpful