SQL Studio - How to back-up all settings

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
mpalmer
Posts: 4
Joined: Sat 22 Jun 2019 19:02

SQL Studio - How to back-up all settings

Post by mpalmer » Tue 20 Aug 2019 14:36

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?

alexa
Devart Team
Posts: 2857
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Wed 21 Aug 2019 12:24

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...'.

mpalmer
Posts: 4
Joined: Sat 22 Jun 2019 19:02

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

Post by mpalmer » Wed 21 Aug 2019 17:14

Just to confirm: Exporting settings from the tools menu back-us all the aliases & snippets?

alexa
Devart Team
Posts: 2857
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Thu 22 Aug 2019 10:26

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.

mpalmer
Posts: 4
Joined: Sat 22 Jun 2019 19:02

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

Post by mpalmer » Sat 02 Nov 2019 00:09

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?

mpalmer
Posts: 4
Joined: Sat 22 Jun 2019 19:02

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

Post by mpalmer » Sat 02 Nov 2019 00:28

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

alexa
Devart Team
Posts: 2857
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Mon 04 Nov 2019 09:20

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\

mpalmer
Posts: 4
Joined: Sat 22 Jun 2019 19:02

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

Post by mpalmer » Mon 04 Nov 2019 15:27

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.
Last edited by mpalmer on Mon 04 Nov 2019 15:48, edited 1 time in total.

mpalmer
Posts: 4
Joined: Sat 22 Jun 2019 19:02

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

Post by mpalmer » Mon 04 Nov 2019 15:44

Finally got it uninstalled. Not sure what did it, but when I launched SQL Studio, it showed in trial mode.

Thanks for the help!

alexa
Devart Team
Posts: 2857
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Tue 05 Nov 2019 09:22

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.

Post Reply