Create archive file im MD2017

Christian S.'s Avatar

Christian S.

11 Dec, 2018 10:30 PM

How do I create an archive file in MD 2017. The 2015 manual says to do it from the "File" menu, where there should be an option to "Archive". However, in MD 2017 the file menu does not seem to have that option. So how can I create an archive file?
My MD file as grown very big, so MD is very slow to open and close, so I would like to archive some of the data to get a smaller "current" MD file, like I have done in the past.

  1. 1 Posted by dwg on 11 Dec, 2018 11:03 PM

    dwg's Avatar

    I'm a fellow user.

    The archive option was removed in one of the Moneydance 2015 releases, it was causing Data Integrity issues.

    Even if it worked perfectly however using it would not make your data set smaller, it would in fact make the data set larger, due to the way writes data as a series of changes rather than a modification of the original entry, so any archive process would have the effect of the original transaction being there then there being a new transaction to delete it.

  2. 2 Posted by Christian S. on 11 Dec, 2018 11:36 PM

    Christian S.'s Avatar

    So how do I make my file smaller? How do I split it into two files covering an "archived" period and a current period?

  3. 3 Posted by dwg on 12 Dec, 2018 12:00 AM

    dwg's Avatar

    I certainly know of no way of splitting the file(s)

    There is no current supported way of making the data set smaller - the problem usually stems not from the size of the data but the fact that Moneydance uses a type of journaling so there are a large number of small files.

    A number of users have suggested different approaches that a user can use to address this but for every approach someone can be found who believes it causes or can potentially cause problems. The best I can say is as users we do not have enough information to really know what can and cannot be done and all possible implications.

    The next version of Moneydance is supposed to have better housekeeping

  4. 4 Posted by Christian S. on 14 Dec, 2018 06:42 PM

    Christian S.'s Avatar

    I would welcome a response from Infinite Kind.

    Christian S.

  5. 5 Posted by Christian S. on 18 Dec, 2018 06:51 PM

    Christian S.'s Avatar

    Hello again Infinite Kind,

    Is anyone going to respond to my support request. It is now a week old!


    Christian S.

  6. 6 Posted by derekkent23 on 18 Dec, 2018 07:11 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    The following is an answer today by the Moneydance software developer, Sean, to a similar question to yours. Hope it helps.

    “the reason it takes so long is that MD archives the entire data file, which is a cumulative list of all changes ever made to the file. For that reason, the "archive" function didn't reduce the size of the file but could often increase the size. This is because removing old transactions increased the number of changes and thus the size of the file. The about-to-be-released MD2019 does an internal archive by compressing and consolidating the internal change-log files which reduces the size of the overall file but (more importantly) vastly reduces the number of change-log files that it needs to scan at launch and shutdown.”

  7. 7 Posted by Christian S. on 18 Dec, 2018 07:46 PM

    Christian S.'s Avatar

    Hi derekken123,

    I appreciate your response and the explanation below. However, it used to be possible in the past to split your Moneydance file into smaller files, each covering a few years.
    Every couple of years I would create an "archive" file covering a couple of years, and then a current file. I don't need 10-15 years of checking or credit card data in the current file, but it was nice to have the option of going back occasionally to look for a very old transaction. And each of these smaller files opens much faster then the current huge file.

  8. 8 Posted by derekkent23 on 18 Dec, 2018 07:57 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    From comments from Sean Archiving (splitting files) has gone for good. Apparently, it created more problems than it solved for users with Security investment accounts.
    If you upgrade to 2019 when its out of beta testing and released, it would be interesting to know if it reduces the data set size and also speeds up opening and closing as Sean seems to think.

  9. 9 Posted by Christian S. on 10 Jan, 2019 08:07 PM

    Christian S.'s Avatar

    Hello Infinite Kind,


    Are you ever going to respond?


    Christian S.

  10. Support Staff 10 Posted by Henry on 16 Jan, 2019 02:15 PM

    Henry's Avatar

    I apologize, I have answered your new discussion and will continue there.

    Infinite Kind Support

  11. Ethan closed this discussion on 01 Feb, 2019 03:32 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac