How to Seamlessly Transfer SQL Workbench/J Profiles to a New Windows PC

When you get a new Windows PC, one of the tasks you'll need to tackle is transferring your setup from your old machine to the new one. While many modern applications are cloud-based and easy to configure with just a few clicks, desktop SQL clients like SQL Workbench/J require a bit more work. This is especially true if you have multiple server connections configured, with details like server IPs, usernames, and credentials that you'd rather not re-enter manually.

Luckily, transferring your SQL Workbench/J setup is straightforward. Here’s how you can do it:

Step 1: Locate and Download the SQL Workbench/J Configuration Folder

Your SQL Workbench/J configurations are stored in a folder typically located at:

C:\Users\<your-username>\.sqlworkbench

To make things easier, zip the entire .sqlworkbench folder to prepare it for transfer. Files within that look like this:

Step 2: Transfer and Unzip the Folder on Your New PC

Move the zipped folder to your new PC using your preferred method (USB drive, cloud storage, etc.). Once transferred, unzip the folder and place it in the same directory on your new PC:

C:\Users\<your-username>\.sqlworkbench

Final Step: Launch SQL Workbench/J

After copying the files, simply open SQL Workbench/J on your new PC. You’ll find all your previous configurations, including server connections and credentials, just as you left them on your old machine.

Bonus Tip: This method not only transfers your connections but also retains all your previously saved SQL queries, so you can pick up right where you left off without any extra effort.