Versions Compared

Old Version 21

changes.mady.by.user Russell Shirley

Saved on

compared with

New Version 22

changes.mady.by.user Russell Shirley

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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 

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)

  1. Hardware and Software Requirements for MSSQL 2016 SP1
  2. Feature Pack details for MSSQL 2016 SP1
  3. Release Notes MSSQL 2016
  4. Whats New in MSSQL 2016


MSSQL 2014 R2 - Enterprise edition

  1. Hardware and Software Requirements for Installing SQL Server 2014
  2. Feature Pack details for MSSQL 2016 SP1
  3. Release Notes MSSQL 2014
  4. Whats New in MSSQL 2014



NOTE:  If you foresee the need to perform audits of the database, consider using MSSQL 2016 Service Pack 1 Standard/Enterprise Editions

Info

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.


Other Resources:

  1. SQL Server Storage Best Practices
  2. MSSQL Backup Best Practices

Filter by label (Content by label)
showLabelsfalse
max5
spacesACD
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "mssql" and type = "page" and space = "ACD"
labelsMSSQL

Page Properties
hiddentrue
Related issues