MYOB Backups
Hi
I've noticed that the latest version of MYOB 2026.5 no longer has the facility for a local backup.
This is problematic for some of my clients as they want to have their own backups on their lo...
Forum Discussion
Hi Mydataxport
Interesting. I know my way around all of the Endpoints with apps for clients reading and writing. Reading is a lot easier.
What format is the data downloaded to? - i.e. what database?
What would be neat is grabbing that data and re-building an AR SE 2026.5 SQL CE format which actually is part of Microsoft Visual Studio drivers - interestingly.
I use V S all the time for my VB.NET and VC#.Net apps - might do some investigating, and see what I can find out.
For your info I do not use MYOBs SDK for accessing their API - wrote all my own read/write endpoint accesses.
The Doc
Hi Doc
At present, MyDataXport does not download the information into a single database.
The accounting data is exported into structured Excel and CSV files, with reports and the attachments made available through MYOB’s API saved into organised folders in the business’s own Google Drive, OneDrive, or Dropbox.
The attachments are retained as actual files rather than being embedded within a database. We also use meaningful file names and folder structures so they can be searched and matched back to information such as the transaction date, supplier or payee, transaction number and document type.
The cloud storage can, of course, also be synchronised to a local computer, server or NAS if the business wants its own local copy.
So the current output is an independent, open-format archive rather than an SQL CE database or an AccountRight restore file. MYOB remains the live accounting system.
Rebuilding an AR SE 2026.5 SQL CE file is certainly an interesting idea. I expect the challenge would be less about accessing SQL CE through Visual Studio and more about accurately recreating MYOB’s complete internal schema, relationships, identifiers, validation rules and any objects that are not exposed through the public API.
We have deliberately not gone down that path because the aim of MyDataXport is to create a durable and searchable archive that remains readable without relying on a particular version of AccountRight. Reconstructing a valid AccountRight file would be a separate and considerably different technical project.
Given your experience with the MYOB endpoints and writing your own read/write integrations, I would certainly be interested to hear what you uncover.
Hi Mydataxport
Took me an hour - my visual studio 22 Pro is now opening .myox files - and I have full read/write to them and the complete database layout and schema and all the data is there in read/write.
This is now very interesting progress - going to have a play!
Enough said.
The Doc
Hi Mydataxport
I will let you know if I need a project to keep my brain active - ..... but a neat challenge to think through.
Might have a go - ....
The Doc
