What back end database should I choose to use with Synergy?

Synergy offers two main database engines at the time of writing, although other database engines are theoretically possible if someone needs them and is willing to pay to have the necessary additions implemented. If you need Oracle, DB2, MySql, or something similar contact support to discuss your requirements.

The currently available options are:

  1. The embedded database engine supplied with Synergy as standard
  2. Microsoft SQL Server: Express and Full editions from 2012 onward are officially supported, 2008 onward will work at the time of writing but we cannot guarantee to continue to support it simply because Microsoft are no longer supporting it.

The choice of engine will depend upon the number of machines that you want to use any Synergy database at the same time. As a general rule, although the standard database engine can be run with multiple concurrent users it will be at the mercy of your operating system and its file and record locking limitations. If you will have multiple users connecting to and wanting to use the data at exactly the same time then a SQL Server database will give better performance.

A good rule of thumb is that for anything more than two or three concurrent users actively accessing data at the same time a SQL Server database is pretty much essential for top quality performance. The SQL Server Express edition is free to download and use, and is a good option for a small businesses who will not have vast amounts of data and a maximum of say up to four or five concurrent users. As the requirements of the business grow, you can choose to upgrade to a full version SQL Server installation.

Note: In order to use the Microsoft SQL Server database engine you will need to have the SQL Server Database Module installed and active on each machine. You can use an existing installation if you already have one, consult your IT support team to find out what may already be available, or you can install a copy specially. Synergy Accounts Ltd does not offer support for your hardware infrastructure, so whilst we are happy to advise and work with your IT support team we cannot install or maintain your network or database installations.

Posted on:

Key Benefits

  • Synergy works tirelessly for your business
  • Quickly adapts to suit the needs of your business
  • Designed to develop and grow with your business
  • Intuitively easy to use and simple to set up
  • Helps save you time and manage your business more effectively
  • Plugins for additional areas such as Stock, Payroll, Sales Orders and more
  • Custom modules available for any specialised needs your business may have
  • Ongoing, accessible and responsive support packages mean help is always at hand
  • HMRC recognised for Making Tax Digital

Watch our latest video...

See more videos

What our customers say

Back in 2015 and with much trepidation we took on the Synergy accounting software. Being a bit of a technophobe I was very concerned about keeping it up to date and everything in order, particularly as I hate anything to do with figures. The support has been immense and I am sure he must think that he is my accountant sometimes, however, he never makes me feel that I am being a pain in the neck, although I am sure he dreads my number coming up on his phone. Synergy does everything that my company needs, in spite of the me. When it came to the year-end accounts, it was just a case of printing off some reports and sending them off to the accountant. This leaves me in a position to renegotiate my accountants fee, as most of the work is done for him. After using Excel and trying Zero, Synergy has been well worth the investment and with the magnificent support... it is unbeatable.

Open House Estate Agents