SQL Studio - Recover previously unsaved .sql

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

SQL Studio - Recover previously unsaved .sql

Post by mpalmer » Mon 03 Feb 2020 00:58

Recover previously unsaved .sql files with SQL Studio?

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

Re: SQL Studio - Recover previously unsaved .sql

Post by alexa » Mon 03 Feb 2020 15:22

You can select the restorable file types in the 'Environment -> Documents -> Restore' section of the 'Options' window (select 'Tools -> Options...' from the main menu).

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

Re: SQL Studio - Recover previously unsaved .sql

Post by mpalmer » Mon 03 Feb 2020 15:56

Right...but how do I recover previous .sql files?

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

Re: SQL Studio - Recover previously unsaved .sql

Post by alexa » Mon 03 Feb 2020 16:41

The restorable files with corresponding paths are specified in the *.xml file that is located in the following folder:

Code: Select all

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

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

Re: SQL Studio - Recover previously unsaved .sql

Post by mpalmer » Mon 03 Feb 2020 18:12

First...it's strange that I have to find a hidden .xml file and decipher it to locate the files. Second, it's even stranger that the saved files are stored as .cache files and I have to rename them to .sql. SQL Studio doesn't have functionality within the program to explore and recover previously saved files???

The previously unsaved files are not in the recovery directory - why would they have been deleted?

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

Re: SQL Studio - Recover previously unsaved .sql

Post by alexa » Tue 04 Feb 2020 08:57

This may happen due to abnormal program termination or system shutdown.

Did you exit dbForge correctly before the files were lost?

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

Re: SQL Studio - Recover previously unsaved .sql

Post by mpalmer » Tue 04 Feb 2020 19:02

I'm not sure...but the point of being able to restore is largely applicable to application crashes. This should be a standard feature. I've used other SSMS alternatives that do exactly this.

Recovering from a crash is the main purpose of restoring unsaved files

Also, why doesn't SQL Studio have the functionality to restore previous files from within the program, rather than have to open an .xml file??

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

Re: SQL Studio - Recover previously unsaved .sql

Post by mpalmer » Fri 07 Feb 2020 16:42

Can someone help me understand the purpose fo this functionality if it can't recover .sql files after a crash?

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

Re: SQL Studio - Recover previously unsaved .sql

Post by alexa » Tue 11 Feb 2020 14:15

We will investigate this issue and will answer you as soon as possible.

Post Reply