- #Adventureworks database for sql server 2012 download how to#
- #Adventureworks database for sql server 2012 download install#
- #Adventureworks database for sql server 2012 download download#
Assuming that the connection is successful, the following screen will be shown:ġ6. Test the connection by clicking "Test Connection". Log on to the server by entering your credentials and select the AdventureWorksDW2012 database to connect to.ġ4. Click "Edit" the "Connection string" to launch the "Connection Manager".ġ3. Open up the "AdventureWorksDW2012.ds" file by double-clicking on it.ġ2. Click "Start Visual Studio" and the AdventureWorks solution will be opened in VS2010.ġ1. If prompted to enter the default environment settings for Visual Studio 2010, select "Business Intelligence Settings".ġ0. Double-click on the "AdventureWorksDW2012Multidimensional-EE.sln" file to open it in Visual Studio 2010.ĩ. Notice that there is a file called "AdventureWorksDW2012Multidimensional-EE.sln".Ĩ. A confirmation screen is shown to "Apply changes to this folder, subfolders and files".ħ. Uncheck the "Read-only" property and then click "OK".Ħ. Right-click on the " “AdventureWorks Multidimensional Models SQL Server 2012" folder and click on "Properties".ĥ. Unzip the “AdventureWorks Multidimensional Models SQL Server 2012.zip” file.Ĥ. Put it in, for example, location "C:\AdventureWorks Cube".ģ. The result is that a file called “AdventureWorks Multidimensional Models SQL Server 2012.zip” is download. Choose the “AdventureWorks Multidimensional Models SQL Server 2012” download. Click on “SQL Server 2012 OLTP” and you will be directed to the Downloads page for SQL Server 2012.
#Adventureworks database for sql server 2012 download install#
Install the sample AdventureWorks cube onto SQL Server 2012 Analysis Services Follow these steps:Ģ. Now the AdventureWorks database is attached. Remove the “AdventureWorks2012_Log.ldf” file by clicking the “Remove” button.ġ1. Click “Add” and select the “AdventureWorksDW2012_Data.mdf” database.ġ0. Right-click “Databases” and click “Attach”.Ĩ. Launch Microsoft SQL Server Management Studio and select "Server Type" = "Database Engine".ħ. Copy the “AdventureWorksDW2012_Data.mdf” file to the Microsoft SQL Server DATA folder as follows:Ĭ:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATAĥ. Click on the “AdventureWorksDW2012 Data File” so that the “AdventureWorksDW2012_Data.mdf” file is downloaded.Ĥ. Click on “SQL Server 2012 OLTP” and you will be directed to the Downloads page for SQL Server 2012.ģ.
#Adventureworks database for sql server 2012 download download#
Go to the following CodePlex download page:Ģ. Steps A summary of what needs to be done is as follows: Install the sample AdventureWorks database onto SQL Server 2012 Follow these steps:ġ. Copy the script below and modify the path to the MDF file as according to your environment and click Execute.The purpose of this page is to describe where to obtain the sample Adventureworks database and multidimensional database (cube) as well as describe the process of bringing them into SQL Server 2012.Connect to the SQL Server and click on New Query.Open SQL Server Management Studio as Administrator.For more information, see View or Change the Default Locations for Data and Log Files (SQL Server Management Studio). Note: The default location for storing data and log files of SQL Server 2012 Express (圆4) is C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA. In this example, I keep it in C:\databases. Place the downloaded file (the MDF file) to your database folder.Download “Adventure Works” sample database from CodePlex at Adventure Works for SQL Server 2012 by select AdventureWorks2012 Data File.Step-by-step to install sample database Adventure Works
#Adventureworks database for sql server 2012 download how to#
On this post, you will see step-by-step guide how to attach/install sample database Adventure Works on SQL Server 2012 Express using SQL Management Studio.
0 kommentar(er)
