The sample data after SQLServer2005 is "AdventureWorks", which must be downloaded from the codeplex website. The purpose of this design is to allocate unnecessary users and permissions to the production database. In addition to the differences in versions, you can also distinguish between OLTP and DW from the following URLs. Select the corresponding version for download. In general, backward compatibility, so
The sample data after SQL Server 2005 is named "AdventureWorks" and must be downloaded from the codeplex website. The purpose of this design is to allocate unnecessary users and permissions to the production database. In addition to the differences in versions, you can also distinguish between OLTP and DW from the following URLs. Select the corresponding version for download. In general, backward compatibility, so
The sample data after SQL Server 2005 is named "AdventureWorks" and must be downloaded from the codeplex website. The purpose of this design is to allocate unnecessary users and permissions to the production database.
Access from the following URL
In addition to the version differences, there are also OLTP and DW differences, select the corresponding version for download. Generally, this is backward compatible, so we use AdventureWorks2012 as an example.
Data can be downloaded in multiple ways, such as directly downloading the mdf file, using scripts for installation, or using backups for restoration. It saves time and effort to download mdf for direct Attach.
To install AdventureWorks2012 OLTP database
Download the AdventureWorks2012 Data File.
From the License Agreement, click I Agree.
From File Download, click Save and browse to a location on your local server.
From SQL Server Management Studio, execute the following code: change the path name.
USE [master]
GO
FORATTACH
GO
Detach script
USE [master]
GO
EXECmaster. dbo. sp_detach_db
GO
To use the graphic interface attach, remove the default Log files.
Microsoft Sample Database Help documentation
# Readme_for_Adventure_Workus_Sample_Databases
Sample Database