However, Microsoft has introduced little design complexity in these databases, which make it little harder to understand. ![]() I normally use AdventureWorks2008 for my training and learning purpose. AdventureWorks2008 contains sample data in to test newer features that SQL Server 2008 offers. ![]() We get separate installer in order to install these databases in case of SQL Server 2008.ĭon’t worry! I’m going to describe all these versions over here.ĪdventureWorks/AdventureWorks2008: AdventureWorks and AdventureWorks2008 are principally OLTP databases. These are no longer built-in features of SQL Server 2008. With SQL Server 2008, newer versions of AdventureWorks databases came into being – that is, AdvenutureWorks2008, AdventureWorksLT, AdventureWorksLT2008, AdventureWorksDW2008. As a result, the AdventureWorks sample database was released with SQL Server 2005. If I remember correctly, at first SQL Server 2005 came up with AdventureWorks and AdventureWorksDW databases and it has been an optional feature during SQL Server installation. it felf the need for different sample databases, which can be used to test these features. We can restore this database on SQL Server 2008 as well.īut, when Microsoft added new features like Reporting Services, Analysis Services, etc. Still, it was great for learning and trying out SQL Server new features. The Northwind was again a sample OLTP database but with little design issues. I’m sure a lot of professionals, especially trainers, do use this sample database till date. When SQL Server 2000 was released, it came up with new sample database, named Northwind. But, there were a lot of shortcomings in this database as it was not designed properly. We can run the pubs database script and restore it on SQL Server 2008 as well. This smaple database remains there until now. This is very basic OLTP database in order to try SQL Server features and learn SQL Server. Microsoft provided ‘ pubs‘ sample database with SQL Server 6.5. So, the story starts since very beginning. Hence, I decided to write about it today. And, I often come across one more question, which is relevant to AdventureWorks database – that is, Why do we have so many different types of AdventureWorks sample databases such as AdventureWorks, AdventureWorks2008, AdventureWorksLT, etc.? Frankly speaking, I got no correct answer from anyone so far. AdventureWorks2012_log.Yeah! This is very common question among professionals, especially those are learning the SQL Server. ![]() AdventureWorks2012_Data.mdf – This is the database data file.Unzip the AdventureWorks2012_Data.zip file to a temporary folder.Locate and download the AdventureWorks2012_Data.zip file.Open the web site and click on the icon for SQL Server 2012 OLTP.AdventureWorksDW2012_Data This is the data warehouse / analytics schema for AdventureWorks. ![]() AdventureWorks2012_Data This is the OLTP Schema for AdventureWorks.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. 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. 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |