Solved

Where can i get SQL Server DB Samples

Posted on 2013-01-28
10
183 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 250 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 80

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 250 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

828 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