SQL Studio - How to back-up all settings

[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?

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

[mpalmer]

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

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

[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?

[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

[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\

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

[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!

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