Recent versions of MYOB have changed databases to utilise and SQL Compact database. There are often many cases where you need to access this data directly, or perform administrative functions – most notable compaction to reduce file size.
There are a number of tools available to manage SQL compact files, however most of them either;
- Don’t support older SQLCE versions
- Don’t allow opening of non-sdf format files
The SQL Compact Query Analyzer (https://sqlcequery.codeplex.com/) can access MYOB files, but will not allow you to open them with their standard extension. We created a modified version that will handle the MYOB (.myox) extension. Simply select your MYOB database and you can see the datatables.
Our modified version for accessing and compacting MYOB SQL Files can be accessed here: http://www.blueskycont.com/MYOBSQLAnalyzer.zip
It is important to note, that we make no claim to the product, we have only modified the code to support MYOB extensions. We make no representations regarding the software and it is entirely at the users risk. We use this program ourselves to reduce the size of databases for ourselves and our clients, but that does not come as any kind of warranty. We have made our modification available to the community and provide no support. All credit for the application belongs to the original authors at https://sqlcequery.codeplex.com.
The most common use for this application is reducing the size of MYOX files. Remember to backup your database before doing anything. This application can reduce file sizes by more than 90%.
- Install the software (it is a basic Microsoft .NET application, source code available at https://sqlcequery.codeplex.com/SourceControl/latest)
- Select your file at the dialog which is presented when the application runs, or use the ‘File=>Open Database’ option. Please note, the default file type is for .sdf files, you will need to change this to MYOB (.myox) or all files.
- When the file is open, select ‘Database => Compact’
- Your database will be compacted ready for emailing, or just less bandwidth for backup.
We hope this is of assistance.