Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Where can i get SQL Server DB Samples

Posted on 2013-01-28
10
Medium Priority
?
187 Views
Last Modified: 2013-01-28
Hello,
For my testing purposes, you know when can i find SQL Server DataBases so i can test my environment ?

Thanks,
0
Comment
Question by:namerg
10 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 38827898
0
 
LVL 4

Expert Comment

by:MimicTech
ID: 38827904
what are you testing? A database is a very specific thing that stores data that pertains to a given application/context, etc. Unless your testing a database tool, I don't understand why you would want random databases.
0
 
LVL 13

Accepted Solution

by:
Ugo Mena earned 1000 total points
ID: 38827923
2nd Codeplex.

you can also try http://dumps.wikimedia.org/ The Wikimedia dump service.

Where raw database tables in SQL form can be downloaded.
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 

Author Comment

by:namerg
ID: 38828222
Perfect,
I have installed the the database and the OLTP script.

But how do i know if the database is fully functional ?

You know, like access, there is gui to enter records and so on. thanks for your help.
0
 
LVL 84

Expert Comment

by:David Johnson, CD, MVP
ID: 38828911
0
 

Author Comment

by:namerg
ID: 38829279
I have done that since the installation of sql
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 38829292
>But how do i know if the database is fully functional ?

from management studio, you cal connect to the server , from the left pane you can expand databases -> tables and then right click and open the table

if you know the table,  you can use an insert script or select script to query the databse
0
 

Author Comment

by:namerg
ID: 38829304
Let me rephrase,
that is sample database and I am assuming you can have the pre-established queries, or qui in order to manipulate and enter that information.

And, i do not know the table. I do not know anything about that sample database

Do you the Access sample databases ? You see the data entry gui plus the database.

Thanks,
0
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 1000 total points
ID: 38829320
If you are talking about the advwntureWorks database from CodePlex (Microsoft), the tables are populated with sample data; the queries you can find on BooksOnline or Micorsoft msdn
Check this
http://msdn.microsoft.com/en-us/library/ms187731.aspx
0
 

Author Comment

by:namerg
ID: 38829376
Got it. Thank you.
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question