As any business grows, their ERP solution needs the capability to handle the growing scale of data and operations. With Microsoft SQL Server powering Sybiz Vision and Sybiz Visipay, your business has that capability. However, not all versions of Microsoft SQL Server provide the same scalability and power.
Express or Standard?
The no cost option of SQL Express makes it seem an attractive choice but there are a number of features it lacks which can hinder the performance of your ERP solution. Firstly, SQL Express is severely limited in memory and database size compared with SQL Standard.
There is also a range of features provided in SQL Standard not offered in Express, including log shipping, backup compression and encryption, analysis and reporting services, data transformation, and notification services – some or all of which may be useful to you and your Business Partner for any support and consulting.
The flexible pricing depending on your system and user requirements also means you get the right option for your business needs.
Which version do I need?
New functionality is continuously being added to Sybiz Vision and Sybiz Visipay, utilising more of the capability of Microsoft SQL Server. As Sybiz solutions integrate more of your critical business operations, older versions of SQL Server do not provide the required speed and reliability.
Sybiz Vision and Sybiz Visipay version 17 and above require SQL Server 2012 as a minimum requirement. Before upgrading from any lower version of Sybiz Vision and Visipay, it is important you speak to your Sybiz Authorised Business Partner or IT consultant about your current version of SQL Server.
At the time of writing, Microsoft SQL Server 2017 is the current version and is the recommended version to upgrade to when using Sybiz products.