Adventureworks sample database 20123/19/2024 ![]() ![]() I would like to mention one more important point over here. Therefore, it’s easier to understand these OLAP databases. Sorry! but I’m unable to describe what a data warehouse is over here. These databases are used to test and see the Analysis Services features. I would rather say these have have been designed with OLAP approach. These databases get the historical data from AdventureWorks and AdventureWorks2008 OLTP database respectively and create a data warehouse. I find it easier too.ĪdventureWorksDW/AdventureWorksDW2008: Here, the word ‘ DW‘ stands for Data Warehouse. Again, these are an example of OLTP model. These are used by a lot of trainers to teach basics of SQL Server. Actually, these are a subset of AdventureWorks and AdventureWorks2008 databases. But, once you get the concept over here, I’m sure you will definitely appreciate these databases.ĪdventureWorksLT/AdventureWorksLT2008: Here, the word ‘ LT’ stands for Lite. 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. We can restore this database on SQL Server 2008 as well.Yeah! This is very common question among professionals, especially those are learning the SQL Server. ![]() Yeah! This is very common question among professionals, especially those are learning the SQL Server. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |