U4BW – Windows and SQL Server Versions
UNIT4 Business World (Agresso) is now supported on Windows Server 2016 and SQL Server 2016 which can offer enhanced performance, security and high availability features such as SQL Server Availability Groups.
SQL Server High Availability Groups were first introduced in SQL Server 2012 as an Enterprise Feature. In SQL Server 2016 Standard Edition, Basic Availability Groups are now available.
Basic Availability Groups are a cut-down version of the Enterprise offering. They do however fit quite well with the U4BW setup and can be used to provide a very good High Availability / Disaster Recovery setup for a relatively low cost.
The setup can be:-
- Both servers on-premise
- Both servers cloud based
- Primary server on-premise and secondary server cloud based (Hybrid Cloud)
In each setup there are advantages and disadvantages. But each one offers a great solution compared to a single server.
The following table shows which versions of U4BW are supported on Windows Server 2016 and SQL Server 2016. (Please note, SQL Server 2016 doesn’t need Windows Server 2016 and will run on Windows Server 2012 R2.)
|U4BW Version||SQL Server 2016||Windows Server 2016|
|Milestone 5||Yes||Requires UPDATE05|
|Milestone 6||Yes||Requires UDPATE03|