Identify The Workstation
To create a database backup from Webgility, although you can initiate it from any workstation, you might need to identify where SQL is installed as the .bak file will get created where the SQL is installed.
To identify the correct name of the workstation, here are the steps:
1). Go to C:\Webgility\UnifyEnterprise\XML and open apiconfig in a Notepad
2). In the apiConfig, on the first line you will see the name of the workstation as shown in the screenshot below:
Once you are on the primary machine, follow these steps:
Create a Database Backup
1). Launch and log into Webgility, and go to the Dashboard of any of your sales channels. From the top menu bar, go to System> Database> Backup.
2). Choose a location to save the backup. Then click OK.
Due to local security on the workstation, we advise using the default selected location.
3). Depending on how much data is being put into the backup, this can take a few minutes. Once it is completed you will see a success message.
4). The default location for the database will be C:\Webgility\UnifyEnterprise and the file type is .bak
It is a good idea to move your backup to a different machine or backup directory to retain it.
5). These were the steps of creating the Webgility database backup.
Restore a Backup
If you are moving a database to a different machine or recovering from a system failure you may need to restore your database from a backup so you do not lose any work or settings. Follow these steps to restore your database.
In case of a system failure, restoring the database will need to be done after installing the Webgility application and SQL.
1). From the header bar in Webgility go to System> Database> Restore.
2). You will receive a popup warning you are about overwriting the existing data. Click Yes to proceed.
3). Browse for your most recent UnifyDB.bak file and click Open.
4). After a few moments, you will receive a success message. Dismissing this message closes the software. When you relaunch, you will see your data restored.