Hi All,
This post is for Adventure Works Sql-Server sample database. Many time we need a sample database to perform our query and operation. AdventureWorks is the Microsoft's open source database. There are different-2 method to download and install the AdventureWorks but here i'll mention the method which i feel easy.
Below is the link to download the script and data files.
Click here : AdventureWorks 2008 OLTP Script
OR
AdventureWorks 2008R2 OLTP Script
Click on the above link and download the full files. Extract it some where in your PC. Open the folder there you will find "instawdb.sql" file open it.
un comment "SqlSamplesDatabasePath" and "SqlSamplesSourceDataPath" variable and change the path.
Now in menu select Query>SQLCMD Mode.
Execute the script.
Now this AdventureWorks sample database is intalled in your computer.
Thx,
RS
This post is for Adventure Works Sql-Server sample database. Many time we need a sample database to perform our query and operation. AdventureWorks is the Microsoft's open source database. There are different-2 method to download and install the AdventureWorks but here i'll mention the method which i feel easy.
Below is the link to download the script and data files.
Click here : AdventureWorks 2008 OLTP Script
OR
AdventureWorks 2008R2 OLTP Script
Click on the above link and download the full files. Extract it some where in your PC. Open the folder there you will find "instawdb.sql" file open it.
un comment "SqlSamplesDatabasePath" and "SqlSamplesSourceDataPath" variable and change the path.
Now in menu select Query>SQLCMD Mode.
Execute the script.
Now this AdventureWorks sample database is intalled in your computer.
Thx,
RS
No comments:
Post a Comment