SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQLA: 13.5 "Recent Documents"

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQLA: 13.5 "Recent Documents"
Author Message
Mindflux



Joined: 25 May 2013
Posts: 851
Country: United States

Post SQLA: 13.5 "Recent Documents" Reply with quote
It does not appear that 13.5 w/ SSMS 21 brings over "recent documents".

I would think that this might be a 32-bit vs 64-bit issue? Maybe the SQLLite (or whatever you use to store document history) is where the issue lay?
Fri Jun 27, 2025 9:47 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7962

Post Reply with quote
This stuff is stored in the History folder which isn't version specific.
Looking into that...
Fri Jun 27, 2025 12:36 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 851
Country: United States

Post Reply with quote
I thought at one point it got converted to a database, because I remember running into an unescaped apostrophe bug when that happened. It used to be stored in a folder, I do remember that.
Fri Jun 27, 2025 1:16 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7962

Post Reply with quote
Actually, could you please check if you got two saDocMng.* files in %APP_DATA%\Roaming\SQL Assistant\13.5 folder? If you don't, or they are small, please copy them from 13.0 folder
Fri Jun 27, 2025 2:03 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 851
Country: United States

Post Reply with quote
The 13.0 had a "saDocMng.db.bak" file, I copied that into the 13.5 folder and renamed the current .db to db- and renamed the .bak to .db (being careful it didn't end up .db.db), but that did not fix it. I closed SSMS before hand to avoid any file locking.

The saDocMng.db.bak was about 2MB and had a modified date from earlier this morning.

There was also a saDocMng.xml.bak, but I did not copy it as it had a last modified date from quite a bit back.


Update:
Bringing over the saDocMng.xml did not help.
Fri Jun 27, 2025 2:10 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7962

Post Reply with quote
saDocMng.db is the only one that matters, but there could be also and .log file for the same. 2MB is promising, it's a good sign there is something.
The .xml file is an artifact from some older version
Fri Jun 27, 2025 4:50 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 851
Country: United States

Post Reply with quote
Yeah unfortunately moving the .db.bak over and renaming it didn't help.

I'm off for a week, so I guess I'll try again the week after next.
Fri Jun 27, 2025 4:55 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.