数据库要求 (Master Data Services)Database Requirements (Master Data Services)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - 仅限 Windows 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Windows only 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance

所有主数据都存储于 Master Data ServicesMaster Data Services 数据库中。All master data is stored in a Master Data ServicesMaster Data Services database. 承载此数据库的计算机必须运行的实例 SQL ServerSQL Server 数据库引擎Database EngineThe computer that hosts this database must run an instance of SQL ServerSQL Server 数据库引擎Database Engine.

使用 Master Data Services 配置管理器Master Data Services Configuration Manager 在本地或远程计算机上创建和配置 Master Data ServicesMaster Data Services 数据库。Use Master Data Services 配置管理器Master Data Services Configuration Manager to create and configure the Master Data ServicesMaster Data Services database on either a local or a remote computer. 如果您将数据库从一个环境移到另一个环境,则可以通过将 Master Data ServicesMaster Data Services Web 服务和 主数据管理器Master Data Manager 与其新位置中的数据库相关联,在新环境中维护这些信息。If you move the database from one environment to another, you can maintain the information in a new environment by associating the Master Data ServicesMaster Data Services web service and 主数据管理器Master Data Manager to the database in its new location.

备注

您安装 Master Data ServicesMaster Data Services 组件的任何计算机必须具有许可证。Any computer on which you install components of Master Data ServicesMaster Data Services must be licensed. 有关详细信息,请参阅“最终用户许可协议 (EULA)”。For more information, refer to the End User License Agreement (EULA).

要求Requirements

在创建 Master Data ServicesMaster Data Services 数据库之前,请确保满足以下要求。Before you create a Master Data ServicesMaster Data Services database, ensure the following requirements are met.

SQL Server 版本SQL Server Edition

Master Data ServicesMaster Data Services 数据库可以承载在以下版本的 SQL ServerSQL Server上:The Master Data ServicesMaster Data Services database can be hosted on the following editions of SQL ServerSQL Server:

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise(64 位)x64Enterprise (64-bit) x64

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) Developer(64 位)x64Developer (64-bit) x64

  • SQL Server 2014 (12.x)SQL Server 2014 (12.x) Business Intelligence(64 位)x64Business Intelligence (64-bit) x64

  • SQL Server 2014 (12.x)SQL Server 2014 (12.x) Enterprise(64 位)x64Enterprise (64-bit) x64

  • SQL Server 2014 (12.x)SQL Server 2014 (12.x) Developer(64 位)x64Developer (64-bit) x64

  • SQL Server 2012 (11.x)SQL Server 2012 (11.x) Business Intelligence(64 位)x64Business Intelligence (64-bit) x64

  • SQL Server 2012 (11.x)SQL Server 2012 (11.x) Enterprise(64 位)x64 - 仅可从 SQL Server 2008 R2SQL Server 2008 R2 Enterprise 升级Enterprise (64-bit) x64 - Upgrade from SQL Server 2008 R2SQL Server 2008 R2 Enterprise only

  • SQL Server 2012 (11.x)SQL Server 2012 (11.x) Developer(64 位)x64Developer (64-bit) x64

  • Microsoft SQL Server 2008 R2 Enterprise(64 位)x64Microsoft SQL Server 2008 R2 Enterprise (64-bit) x64

  • Microsoft SQL Server 2008 R2 Developer (64-bit) x64Microsoft SQL Server 2008 R2 Developer (64-bit) x64

有关 SQL ServerSQL Server各版本支持的功能列表,请参阅 SQL Server 2016 各个版本支持的功能For a list of features that are supported by the editions of SQL ServerSQL Server, see Features Supported by the Editions of SQL Server 2016.

操作系统Operating System

有关 SQL ServerSQL Server 数据库引擎Database Engine支持的 Windows 操作系统和其它要求的信息,请参阅 安装 SQL Server 2016 的硬件和软件要求For information about the supported Windows operating systems and other requirements for SQL ServerSQL Server 数据库引擎Database Engine, see Hardware and Software Requirements for Installing SQL Server 2016.

帐户和权限Accounts and Permissions

类型Type 说明Description
用户帐户User account Master Data Services 配置管理器Master Data Services Configuration Manager中,可以使用 Windows 帐户或 SQL ServerSQL Server 帐户连接到 数据库引擎Database EngineSQL ServerSQL Server 实例以承载 Master Data ServicesMaster Data Services 数据库。In Master Data Services 配置管理器Master Data Services Configuration Manager, you can use a Windows account or a SQL ServerSQL Server account to connect to the 数据库引擎Database Engine instance of SQL ServerSQL Server to host the Master Data ServicesMaster Data Services database. 用户帐户必须属于 实例上的 SQL ServerSQL Server 数据库引擎Database Engine.The user account must belong to the sysadmin server role on the instance of SQL ServerSQL Server 数据库引擎Database Engine. 有关 sysadmin 角色的详细信息,请参阅 服务器级别角色For more information about the sysadmin role, see Server-Level Roles.
主数据管理器Master Data Manager 管理员帐户administrator account 创建 Master Data ServicesMaster Data Services 数据库时,必须指定要作为 Master Data ServicesMaster Data Services 系统管理员的域用户帐户。When you create a Master Data ServicesMaster Data Services database, you must specify a domain user account to be the Master Data ServicesMaster Data Services system administrator. 对于与此数据库关联的所有 主数据管理器Master Data Manager Web 应用程序,此用户可以更新所有模型以及所有功能区域中的所有数据。For all 主数据管理器Master Data Manager web applications associated with this database, this user can update all models and all data in all functional areas. 有关详细信息,请参阅 管理员 (Master Data Services)For more information, see Administrators (Master Data Services).

数据库备份Database Backup

最佳做法是每天在活动较少时进行完整数据库备份,并根据环境需要更频繁地备份事务日志。As a best practice, back up the full database daily at a time of low activity and back up transaction logs more frequently depending on the needs of your environment. 有关数据库备份的详细信息,请参阅备份概述 (SQL Server)For more information about database backups, see Backup Overview (SQL Server).

另请参阅See Also

安装 Master Data Services Install Master Data Services
创建 Master Data Services 数据库 Create a Master Data Services Database
Master Data Services 数据库 Master Data Services Database
"连接到 Master Data Services 数据库" 对话框 Connect to a Master Data Services Database Dialog Box
创建数据库向导(Master Data Services 配置管理器)Create Database Wizard (Master Data Services Configuration Manager)