How to move the Webgility database to a new computer
Learn how to migrate the Webgility database to a new machine.
Database migration is the process of migrating Webgility data from the current server to a new one. A Webgility database backup is needed to restore the database to a new computer after installing Webgility and the SQL server.
Steps to migrate the database to a new server:
Step 1: Create a database backup:
Create a backup of the old database on the old server/computer. Use the following article link to learn how to create a Webgility database backup link.
Step 2: Install the Webgility Desktop app on the new server:
Login to the Webgility portal to download the Webgility installer to install on the new server. For the Webgility installation process, please click on the link.
Step 3: Install the SQL server:
There are two ways to install SQL Server:
Through Webgility application.
Manual installation.
1). Through the Webgility application:
As soon as the user logs in to the Webgility desktop app, they will get the option to install SQL through the application. Select “This is a new computer, install SQL server and create Webgility database” and click Continue.
2). Manual installation:
Please refer to the following help article link to install the SQL server manually. Review the article here link.
Step 4: Restore the database:
Once SQL is installed and a new database is successfully created, you will need to restore the database by selecting the latest database backup file. First, copy the database backup file from the old server/computer and paste it into the Webgility folder on the new server, then select this file to restore the database.
After a successful database restore, please log in to Webgility to open the dashboard. The user can test the store connections and accounting connection in Webgility before downloading the orders and posting the orders to Accounting.
If you receive any error messages after performing the database restore, please reach out to our Webgility Support for help.