This article explains the process of installing the AdventureWorks2016 and AdventureWorksDW2016 sample database on a stand-alone instance of SQL Server and Azure SQL Server. The sample databases were published by Microsoft to demonstrate how to design a database using SQL Server. Microsoft has also published another lightweight database named AdventureworksLT, which can be used as a sample database on Azure SQL Server.
本文介绍了在SQL Server和Azure SQL Server的独立实例上安装AdventureWorks2016和AdventureWorksDW2016示例数据库的过程。 样本数据库由Microsoft发布,以演示如何使用SQL Server设计数据库。 Microsoft还发布了另一个名为AdventureworksLT的轻量级数据库,该数据库可用作Azure SQL Server上的示例数据库。
在独立SQL实例上安装示例数据库 (Installing sample databases on stand-alone SQL instance)
To install AdventureWorks2016 and AdventureWorksDW2016 databases, you must install SQL Server Express/Standard/Enterprise Edition and SQL Server Management Studio.
要安装AdventureWorks2016和AdventureWorksDW2016数据库,必须安装SQL Server Express / Standard / Enterprise Edition和SQL Server Management Studio。
On the stand-alone SQL instance, both databases can be installed by the following methods:
在独立SQL实例上,可以通过以下方法安装两个数据库:
- Direct download and restore the full backup of the database 直接下载并还原数据库的完整备份
- Download the install scripts from GitHub and build the database by executing the script 从GitHub下载安装脚本并通过执行脚本来构建数据库
使用完整备份安装Adventureworks2016 (Install Adventureworks2016 using the full backup)
First, let us install the database using the backup file. You can download the AdventureWorks sample database from the following links:
首先,让我们使用备份文件安装数据库。 您可以从以下链接下载AdventureWorks示例数据库:
- AdventureWorks2017.bak AdventureWorks2017.bak
- AdventureWorks2016.bak AdventureWorks2016.bak
- AdventureWorks2014.bak AdventureWorks2014.bak
- AdventureWorks2012.bak AdventureWorks2012.bak
- AdventureWorks2008R2.bak AdventureWorks2008R2.bak
Once the backup is downloaded, open SQL Server Management Studio and from Object Explorer, expand database engine, right-click on Databases and select Restore Database. See the following image:
下载备份后,打开SQL Server Management Studio,然后从Object Explorer中展开数据库引擎,右键单击Databases并选择Restore Database 。 见下图: