The Meridian Enterprise suite supports the following database management systems.
Local Workspace Data Management
Besides the Microsoft Jet database engine (installed separately) or SQLite (embedded), Meridian Enterprise supports the following database management systems for local workspace data management.
The Express editions of SQL Server are supported for evaluation, development, and demonstration purposes only. They are also supported for the Meridian Enterprise Server configuration database only when Meridian Explorer is not configured. We do not recommend it for any environments. Accruent does not routinely test the Express editions for compatibility, performance, stability, or scalability. When Meridian Explorer is configured, the Standard or Enterprise edition of SQL Server must be used. SQL Server failover clusters are supported.
SQL Server Compact has reached End of Life Status. We recommend transitioning to SQLite.
Microsoft SQL Server Compact Edition
|
Version |
2017 |
2018 |
2019 |
|---|---|---|---|
| SQL Server Compact Edition 4.0 |
supported |
supported |
supported |
| SQL Server Compact Edition 3.5 |
supported |
supported |
supported |
Vault, Configurator, Repository, and Log Database Storage
Meridian Enterprise supports the following database management systems for the storage of Meridian Enterprise vault, Meridian Enterprise Server configuration, Meridian Explorer repository, and Publisher log databases.
Microsoft SQL Server (32-bit and 64-bit versions)
After reviewing the table, read the notes in the expanding sections below for specific requirements, limitations, and exceptions.
Supported Versions Table
| Version |
Meridian Enterprise |
Meridian Enterprise Server |
Meridian Explorer |
Publisher |
|---|---|---|---|---|
| SQL Server 2019 |
supported |
supported |
supported |
supported |
| SQL Server 2017 |
supported |
supported |
supported |
supported |
| SQL Server 2016 |
supported |
supported |
supported |
supported |
| SQL Server 2014 |
supported |
supported |
supported |
supported |
| SQL Server 2012 |
supported |
supported |
supported |
supported |
Notes about SQL Server Express
The Express editions of SQL Server are supported for evaluation, development, and demonstration purposes only. They are also supported for the Meridian Enterprise Server configuration database only when Meridian Explorer is not configured. We do not recommend it for any environments. Accruent does not routinely test the Express editions for compatibility, performance, stability, or scalability. When Meridian Explorer is configured, the Standard or Enterprise edition of SQL Server must be used. SQL Server failover clusters are supported.
Notes about Meridian Explorer
Meridian Explorer only supports the 64-bit versions of Microsoft SQL Server.
Database collation determines if queries and T-SQL script are case-sensitive or case-insensitive. Meridian Explorer requires case-insensitive database collation, which can be set either on the server level or on the database level. To set the collation at the server level, see Set or Change the Server Collation. To set the collation at the database level, see Set or Change the Database Collation.
The Full Text Search component is not installed by default, but is required on servers where repositories will be created. The Full Text Search component is only included in the following editions of SQL Server: Express with Advanced Services, Standard, and Enterprise editions.
Microsoft SQL Server provides a FILESTREAM feature for higher performance that we recommend and is enabled by default during repository creation. Before using this feature, we strongly recommend that you fully understand the advantages, limitations, and implications of the feature by studying the Microsoft SQL Server documentation. For an overview, see Binary Large Object (Blob) Data (SQL Server) on Microsoft TechNet.
Requirements for Versions 2018 R2 and Newer
Beginning with Meridian Enterprise 2018 R2 Update 1, the Microsoft OLE DB Driver for SQL Server must be installed on the Meridian server to create vaults stored in any version of SQL Server. This driver adds support for the latest TLS 1.2 standards and is backward compatible with the SQL Server Native Client but is not included with the client. The driver is required whether TLS 1.2 is used or not.
For more information about and to download the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), which replaces the legacy OLE DB Provider for SQL Server (SQLOLEDB), see:
Oracle
Oracle Standard Edition and Enterprise Edition are supported for all products except Meridian Explorer. We assume that non-Windows versions of Oracle are compatible with the Windows versions (as pertains to Meridian Enterprise compatibility). Accruent supports non-Windows configurations, but does not test them. For more information on testing and supporting non-Windows versions, contact Accruent Technical Support.
The Oracle Text component is not installed by default, but is required on servers where repositories will be created.
Oracle Real Application Clusters (RAC) are supported. Contact Accruent Technical Support for more information.
| Version |
Meridian Enterprise |
Meridian Enterprise Server |
Meridian Explorer |
Publisher |
|---|---|---|---|---|
| Oracle 19c Release 2 (19.0.0.0) |
supported |
supported |
supported |
supported |
| Oracle 18c Release 2 (18.0.0.0) |
supported |
supported |
supported |
supported |
| Oracle 12c Release 2 (12.2.0.1) |
supported |
supported |
supported |
supported |
| Oracle 12c Release 1 (12.1.0.2) |
supported |
supported |
supported |
supported |
| Oracle 11g Release 2 (11.2.0.1) |
supported |
supported |
supported |
supported |
| Oracle 11g Release 1 (11.1.0.7) |
supported |
supported |
not supported |
supported |
SQL Azure
As of the 2022 release, SQL Azure is supported as a database provider for Meridian Enterprise Server. However, there are a few limitations to this support:
-
The setup script should only be used with a fresh installation of Enterprise Server. Any existing configuration will be overwritten or will not be functional anymore.
