Solved

Where can i get SQL Server DB Samples

Posted on 2013-01-28
10
181 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
 

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 79

Expert Comment

by:David Johnson, CD, MVP
ID: 38828911
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

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.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now