Recommended version
MSSQL 2016 Standard or Enterprise versions - Service Pack 1 or higher
(Note: MSSQL 2016 requires use of Server 2012 or higher to operate)
Minimum Required Version
MSSQL 2014 Standard or Enterprise R2
(Note: To enable the AGRIS AUDIT tool MSSQL 2014 Enterprise or higher is required (Available in 2017))
MSSQL 2016 SP1 - Standard or Enterprise (Preferred)
- Hardware and Software Requirements for MSSQL 2016 SP1
- Feature Pack details for MSSQL 2016 SP1
- Release Notes MSSQL 2016
- Whats New in MSSQL 2016
NOTE: If you foresee the need to perform audits of the database, consider using MSSQL 2016 Service Pack 1 Standard/Enterprise Editions
News you can use...
- What should I expect the size per dataset to bet when migrating from PSSQL to MSSQL? Typically the database size will increase by roughly ~4-5X the current size of the pervasive files located in each dataset folder.
- What about using MSSQL Express? In most cases, the typical AGRIS database exceeds the capacity for SQL Server Express.
- SQL Server 2014 Express - Limitations: Microsoft SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage.
https://msdn.microsoft.com/en-us/sqlserver2014express.aspx
- SQL Server 2014 Express - Limitations: Microsoft SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage.
Other Resources:
Related articles
