SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
.mrt and .sas backup files

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
.mrt and .sas backup files
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post .mrt and .sas backup files Reply with quote
I've noticed that there are .mrt and .sas backup files in the folder containing the settings for SA:
Quote:

SqlEditor.2019-07-15-09-18.mrt
SqlEditor.2019-08-05-22-39.mrt
SqlEditor.2019-08-12-10-18.mrt
SqlAssist.2019-07-15-09-18.sas
SqlAssist.2019-08-05-22-39.sas
SqlAssist.2019-08-12-10-18.sas


When/why are they created and how do I disable/prevent creating them?
Fri Aug 23, 2019 7:28 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
These files are store historical changes, in other words they are historical snapshots of the settings. After upgrades and generally if you want to undo some changes, you can use Import/Export feature to copy settings from the historical versions. The files are are fairly small. Are you concerned with them taking much space?
Fri Aug 23, 2019 1:27 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
I'm not really worried about the space they take, though the .sas files do indeed take ~7MB each. But I have that folder versioned in a git repository and those files tend to get in the way. I could ignore them by extension but every once in a while I export a named backup of my .sas/.mrt settings and then I want .sas/.mrt files to be noticed by git.

Besides those files create a clutter there.
Sat Aug 24, 2019 3:11 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
That folder isn't designed for a version control. I'm afraid the backup copies cannot be disabled and saved in a different folder. Their location is likely not customizable.
Maybe it would be better to use a separate folder with clean copies of version controlled files instead of using this one?
Mon Aug 26, 2019 10:08 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
Most folders aren't. But this folder contains settings, tons of them. It's mostly the snippets I've developed over the years, but they are numerous, they are important, and I want to keep an eye on them.

The backup files could be helpful if they only contained the original version of what has been changed. But as far as I can tell they contain the whole backup of the original files and their names (date of change?) are meaningless to me. Having another folder with a clean copy of the relevant files could work, but you see, those backups are just a nuisance. Having to maintain that other folder would be an overhead (copy files there, copy them back upon a repo revert/pull, etc.). I'll skip. Dropping the backup files is much less of a hassle.[/list]
Mon Aug 26, 2019 10:56 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
I'm thinking that you can have clean copies of the files you want in the source control be stored physically in a different folder and symbolically linked to matching names in %APPDATA%\SQL Assistant\11.0. In other words, replace them with symbolic links. Then you can version control that new folder and don't worry about other files created or updated in %APPDATA%\SQL Assistant\11.0, which wouldn't be "visible" in the other folder.

Please take a look at https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/mklink
Mon Aug 26, 2019 11:38 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
I'm familiar with the concept. I've been using that for quite a while for similar purposes until I've run into a couple of "irregular" apps with the better-safe-than-sorry behavior: save it to a temporary file and if that succeeded, rename it to the original name. At first, that might sound good, because you either retain the original file (in case the saving failed), have the changes in the temporary one (if the rename failed), or the save/rename succeeds, and everything is good. And it is until you find out that renaming a non-symlinked file to a symlinked one this way is going to break the link, and that without throwing an error, so it takes a while to figure out where your changes have gone and why the link gets broken.

So to prevent that from ever again happening, I started linking the folders the files were in instead. Actually, that's exactly how my SA settings are kept in the repo:





But if you say that SA is not one of those wicked ones, I'll make SA folder use the "old" method.
Mon Aug 26, 2019 6:12 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
I think it's not. But...
That doesn't apply to the installation process. Every installation will result in the old file getting renamed with a date time suffix. New default file created and custom changes merged. In the end the old file with the symbolic link will be going to git, but that's not the file you need. So I doubt this idea would work well for you.
Mon Aug 26, 2019 6:36 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
Doesn't matter. I'll ignore the files *.sas and *.mrt. I'll have to remember I've made and then forcefully add my named backups of those files. If there were an option to disable the backups, I'd go that way, but as there isn't, this is the next, least painful solution. I can live with it and I'm pretty sure you have more important things to do than introducing an option only one user wants.
Tue Aug 27, 2019 5:53 am 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.