AdventureWorks2012_Data.Unzip the AdventureWorks2012_Data.zip file to a temporary folder AdventureWorks database, available for free download at Imagine that you are a database developer for Adventureworks Bicycles.Locate and download the AdventureWorks2012_Data.zip file. Open the web site and click on the icon for SQL Server 2012 OLTP Place the AdventureWorks2012Data.mdf and AdventureWorks2012log.ldf in the below location C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESSMSSQLDATA 2.Right click on Databases in the object explorer and select Attach 3.AdventureWorksDW2012_Data This is the data warehouse / analytics schema for AdventureWorks.They are also in the SQL Server Sample repository on GitHub. AdventureWorks2012_Data This is the OLTP Schema for AdventureWorks Downloads for older versions of AdventureWorks (2014 and earlier) are archived on Codeplex for your convenience.Note that AdventureWorks has not seen any significant changes since the 2012 version. You may also visit the following site directly: ĪdventureWorks is the name of the fictitious Bicycle company whose database is modeled in the sample SQL Server database. These downloads are scripts and full database backups (.bak) files that you can use to install the AdventureWorks (OLTP) and AdventureWorksDW (data warehouse) sample databases to your SQL Server instance. From the Start menu, click All Programs, click Microsoft SQL Server 2012, click Documentation and Tutorials, and then click Microsoft SQL Server Samples Overview. For more information about installing sample databases and sample code, see the Microsoft SQL Server Community Projects & Samples ().Īdditional information about samples is available after Microsoft SQL Server 2012 has been installed. AdventureWorks actually comprises a family of sample databases created by the Microsoft User Education group as an example of what a ' real ' database. Installing the AdventureWorks Samples in Microsoft SQL Server 2012īy default, sample databases and sample code are not installed as part of SQL Server Setup.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |