4/27/2019
Posted by admin
In this SQL Server lesson we will show you how to download and install AdventureWorks Data Warehouse Microsoft Samples database.
If you want to install SSAS AdventureWorks 2012 Multi-Dimensional database and don't have enough information on how to proceed for the same then this post is designed for you.
1. Open CodePlex and download AdventureWorksDW2012 Data File (DirectLinkToDownload) mdf.
2. Open SQL Server 2012 Database Engine and you can create a relational database using downloaded mdf file. For step-by-step instructions and more details on How-to-attach, you can have a look at technet article.
3. After successful procedure from step2, check whether your relational database instance is showing you the appropriate database named 'AdventureWorksDW2012' under database folder.
4. Go to the CodePlex site and download 'AdventureWorks Multidimensional Models SQL Server 2012' (DirectlinktoDownload).
5. After successful download, you will get a zip file named 'AdventureWorks Multidimensional Models SQL Server 2012', extract the file and go under 'Enterprise' folder. Open Solution file.
6. Check the analysis server name under deployment properties and start deployment. After successful completion of deployment, you will be able to access your 2012 Multi-dimensional cube db.
1. Open CodePlex and download AdventureWorksDW2012 Data File (DirectLinkToDownload) mdf.
2. Open SQL Server 2012 Database Engine and you can create a relational database using downloaded mdf file. For step-by-step instructions and more details on How-to-attach, you can have a look at technet article.
3. After successful procedure from step2, check whether your relational database instance is showing you the appropriate database named 'AdventureWorksDW2012' under database folder.
4. Go to the CodePlex site and download 'AdventureWorks Multidimensional Models SQL Server 2012' (DirectlinktoDownload).
5. After successful download, you will get a zip file named 'AdventureWorks Multidimensional Models SQL Server 2012', extract the file and go under 'Enterprise' folder. Open Solution file.
6. Check the analysis server name under deployment properties and start deployment. After successful completion of deployment, you will be able to access your 2012 Multi-dimensional cube db.
I need to install AdventureWorksLT2012
database but I don't need the .exe
installer instead I need the script file so I can copy & paste it to SSMS 2012 and run it from it so it creates it.
Adventureworks 2012 Download Microsoft
Is there a way to download this script from a website?
pyykke dasherpyykke dasher
closed as off-topic by Raj, Ingo Karkat, Jaco, gotqn, Infinite RecursionFeb 29 '16 at 9:08
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – Raj, Ingo Karkat, Jaco, gotqn, Infinite Recursion
1 Answer
Download Adventureworks 2008
Go to the Microsoft SQL Server sample database page on Codeplex and under Other Downloads
(on the right) you can find
That page then show a lot of downloads - the one you want probably is:
- AdventureWorks 2012 LT Script (third from the bottom)
marc_smarc_s