Page 1 of 1

SQL Studio - How to back-up all settings

Posted: Tue 20 Aug 2019 14:36
by mpalmer
Since upgrading to version 5.7, SQL Studio freezes and locks up.
Even when a query isn't running it hangs and freezes.

I want to completely uninstall it & reinstall: How do I back up all settings, including aliases, snippets, and all my options?

Re: SQL Studio - How to back-up all settings

Posted: Wed 21 Aug 2019 12:24
by alexa
Since upgrading to version 5.7, SQL Studio freezes and locks up.
Even when a query isn't running it hangs and freezes.
Could you please describe when exactly this happens? A video or screenshots would be also of help.

Also, please perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce the issue and send us the *.log file with the latest date from the directory:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\
I want to completely uninstall it & reinstall: How do I back up all settings, including aliases, snippets, and all my options?
This can be performed with the 'Import and Export Settings' feature that can be accessed from the main menu 'Tools -> Import and Export Settings...'.

Re: SQL Studio - How to back-up all settings

Posted: Wed 21 Aug 2019 17:14
by mpalmer
Just to confirm: Exporting settings from the tools menu back-us all the aliases & snippets?

Re: SQL Studio - How to back-up all settings

Posted: Thu 22 Aug 2019 10:26
by alexa
Just to confirm: Exporting settings from the tools menu back-us all the aliases
Yes, you will need to select all the options under 'All Settings -> Options -> Text Editor' for this.
& snippets?
To keep snippets, you need to leave the 'Snippets' option unselected on the UNINSTALL OPTIONS page of the uninstall wizard.

Also, you can backup the 'Snippets' folder that is, by default, located in:

Code: Select all

%ProgramData%\Devart\dbForge Studio for SQL Server\Snippets\
You can change it in the 'Snippets Manager' window that can be invoked by selecting 'Tools -> Snippets Manager...' from the main menu.

Re: SQL Studio - How to back-up all settings

Posted: Sat 02 Nov 2019 00:09
by mpalmer
Uninstalling isn't completely removing the program. When I reinstall all of my previous settings are still present. I checked all boxes in the uninstaller. How do I completely unistall SQL Studio?

Re: SQL Studio - How to back-up all settings

Posted: Sat 02 Nov 2019 00:28
by mpalmer
I even tried a third-party uninstaller that deletes registry keys and leftover files. But after reinstall, all settings are as before. I don't have to enter a license key, my connections are set-up, & the last tabs I had open, are opened again.

I selected to remove everything on the SQL Studio uninstaller

Re: SQL Studio - How to back-up all settings

Posted: Mon 04 Nov 2019 09:20
by alexa
You can also check for the folders below and remove them if needed:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\

Code: Select all

%ProgramData%\Devart\dbForge Studio for SQL Server\Snippets\

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\

Re: SQL Studio - How to back-up all settings

Posted: Mon 04 Nov 2019 15:27
by mpalmer
Thanks - I used an uninstaller that removes registry keys and leftover directories. I also deleted leftover folders in:
%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\


I rebooted and reinstalled and my license and settings are still restored when I reinstall.

Re: SQL Studio - How to back-up all settings

Posted: Mon 04 Nov 2019 15:44
by mpalmer
Finally got it uninstalled. Not sure what did it, but when I launched SQL Studio, it showed in trial mode.

Thanks for the help!

Re: SQL Studio - How to back-up all settings

Posted: Tue 05 Nov 2019 09:22
by alexa
Thank you for updating us on this issue.

By the way the licenses of dbForge products are stored in the following folder:

Code: Select all

C:\Users\<User_Name>\AppData\Local\Devart\Licenses\
So, if you want to switch it to the Trial mode, you can remove the license file for the respective product from that folder.