INSTALL ADVENTUREWORKS DATABASE 2012 HOW TO

When installing from a script, the default database name is AdventureWorks or AdventureWorksDW.

This means you can use either the AdventureWorks or AdventureWorksDW install script on any version of SQL Server including CTPs, SPs, and interim releases. Each script generates the version-specific information based on your current instance of SQL Server. The install scripts create the sample database to have the database compatibility of your current version of SQL Server. PrerequisitesДЇilestream must be installed in your SQL Server instance. To install the AdventureWorks databases with the database compatibility level of your SQL Server instance, you can install from a version-specific backup file or from an install script. The only differences between the various versions of AdventureWorks are the name of the database and the database compatibility level. Note that AdventureWorks has not seen any significant changes since the 2012 version. For a sample database leveraging more recent features of SQL Server, see WideWorldImporters.

AdventureWorks is the OLTP sample, and AdventureWorksDW is the data warehouse sample.Дatabase design has progressed since AdventureWorks was first published.

INSTALL ADVENTUREWORKS DATABASE 2012 HOW TO

The AdventureWorks databases are sample databases that were originally published by Microsoft to show how to design a SQL Server database using SQL Server 2008.

Install adventureworks database 2012