How to Move Webgility Desktop Database to a New Computer and Uninstall SQL Server from the Old Machine
This article helps Webgility Desktop users transition Webgility Desktop to a new computer by guiding them through the proper migration of the Webgility Desktop database and safe uninstallation of SQL Server from the old machine. It provides step-by-step instructions for creating a backup, installing SQL Server and Webgility Desktop on the new computer, restoring the database, and uninstalling SQL Server from the previous system once the migration is successfully completed.
Causes of Issues (if migration isn't done correctly)
-
Missing or outdated database backup
-
Improper SQL Server installation on the new machine
-
SQL logins not recreated post-restore
-
Database restore done to an incompatible SQL version
Step-by-Step Instructions
1. Create a Webgility Database Backup
Before starting, make sure a valid backup of your current Webgility database exists.
🔗 How to Create a Webgility Database Backup
2. Install Webgility on the New Computer
-
Log in to your Webgility account portal.
-
Download and install Webgility Desktop on your new system.
-
Reference: 🔗 Webgility Installation Guide
3. Install SQL Server on the New Machine
Option A: Install Automatically Through Webgility
-
Open Webgility Desktop.
-
Choose:
“This is a new computer, install SQL Server and create Webgility database” -
Click Continue and follow the prompts.
Option B: Manual SQL Installation
If automatic install isn't suitable, refer to:
🔗 SQL Server Manual Installation Guide
4. Restore the Webgility Database on the New Machine
-
Transfer your backup file to the new computer (usually stored under
C:\Webgility\Database Backups
). -
Launch Webgility and open the Database Configuration window.
-
Select Restore Database and browse to your backup file.
-
Follow the prompts to complete the restore.
5. Verify the Migration
-
Open Webgility Desktop and log in.
-
Confirm sales channel and accounting connections work.
-
Try downloading orders or syncing inventory to validate full functionality.
6. Uninstall SQL Server from the Old Computer
Once you're sure everything is running on the new system:
-
Go to Control Panel > Programs and Features.
-
Locate Microsoft SQL Server in the list and select Uninstall/Change.
-
Follow the wizard to remove the SQL instance used by Webgility.
-
Remove additional components like SQL Server Management Studio, if installed.
-
Reboot the computer to finalize the uninstallation.
Notes
-
Always verify your restored database before uninstalling SQL from the old system.
-
Make sure SQL credentials and server instance names are documented for reference.
-
Perform routine backups after migration to prevent data loss.