Keep up to date with our newsletter
There are several compelling reasons to review your SQL Server environment:
MYOB EXO stores all your data within a Microsoft SQL Server database. As such, it is completely reliant on MS SQL Server to operate efficiently and reliably.
MS SQL Server is an extremely efficient and reliable platform if it is kept up to date and is run on a modern server with sufficient resources and an up-to-date operating system.
New features added to your MYOB EXO software inevitably put additional load on your SQL Server. Later versions of SQL Server have significant performance improvements that will speed up your MYOB EXO experience. For example one of our clients went from a 30 minute backup to around 5 seconds. So if you are finding your MYOB EXO experience a little sluggish it could be that a server refresh is overdue.
Another compelling reason for upgrading your SQL server environment is for the new features. For example MS SQL Server 2012 introduced a new running total function that has potential to simplify and speed up reports and functions such as forecast based purchasing, stock rationing and any otherwise time consuming algorithms that rely on running totals.
With each new MYOB EXO release, minimum system requirements are updated and published in the release notes. The SQL Server version forms part of these requirements.
As a Microsoft Gold partner, MYOB have a policy of providing compatibility with new SQL Server versions as soon as practicable after their release. They also drop support for old SQL versions in line with Microsoft dropping mainstream support for the product.
When MYOB drop support for a version of SQL Server it means:
MYOB will not provide technical support for MYOB Exo in unsupported SQL Server environments.
MYOB programmers may utilise SQL Server functionality which does not exist or is not compatible with older versions of SQL Server. This means that the software may not function on an unsupported SQL Server version.
Mainstream support from Microsoft for SQL Server 2005 ended in April 2011 and for SQL Server 2008 and 2008 R2, mainstream support ended in July of 2014. And while both are in extended support, these will end as well – on April 12, 2016 for SQL Server 2005 and July 9, 2019 for SQL Server 2008 and SQL Server 2008 R2.
Below is a chart that outlines the support timeframes for SQL Server:
The implications for those running old versions of SQL Server once end of support happens are:
So get in touch with us today to discuss your SQL Server environment and work out a plan to keep the foundations of your MYOB EXO system up to date.
Tips for creating strong passwords
20 December 2017
4 ways to lose your Office 365 data
15 November 2017
Microsoft Teams: the new way to collaborate with your team
19 October 2017
Disaster Recovery for your Business
04 October 2017
Windows 10 Keyboard Shortcuts
06 September 2017
How to protect yourself against Cybercrime
01 August 2017
For high quality IT Services, Software Development, Accounting Business Software services I would highly recommend Focus Technology Group and their team who have always gone over and above to deliver me outstanding results.
Mark Lovell, Real Journeys
I have enjoyed attending the EXO User Community Workshops and find them very helpful. The group is a valuable resource that provides a great opportunity to discuss issues and solutions with other users. It is also great to learn about new products and features available, and promotes continual improvements which make our use of EXO easier and more efficient.
Graeme Laughton-Mutu, Award Plastics
Focus Technology Group deliver great results by offering true partnership with their clients and I would highly recommend them to anyone looking for a stand out performer in the IT Services, Software Development, Accounting Business Software sector.
Sumaria Beaton, Te Runaka O Awarua
Focus looks after us well. They are conscious that we are a not-for-profit organisation and they consistently bring best-fit, personalised and cost effective - not cheap - solutions to the table.
Sport Southland
Focus ensures they’re always working smarter. Their greatest contribution is in keeping Presbyterian Support Service’s current. Focus keeps us informed and advises us on what we should be considering and how to get there.
Presbyterian Support Southland