From the course: SQL Server: Reporting Services

Set up the example database - SQL Server Tutorial

From the course: SQL Server: Reporting Services

Start my 1-month free trial

Set up the example database

“

- [Instructor] To demonstrate how to build reports with SQL Server Reporting Services, we'll need some data to work with. For this course I'll be using the sample database from Microsoft called Wide World Importers. You can get your own copy from the GitHub project page at this URL. Simply just scroll down on the page and find the link to WideWorldImporters-Full.bak. If you click on that link, it'll download the backup file to your computer. Then we just need to move it into SQL Server's backup folder. To do that you'll copy the file and go into Program Files on your C drive, then into Microsoft SQL Server, then into the folder that represents the server instance that you want to work with. Mine is MSSQL 15.MSSQL SERVER. Yours might have a different version number and server instance name. Once inside of there we'll find MSSQL, and then finally the Backup folder. Go ahead and place your copy of WideWorldImporters-Full.bak right inside of here. Then we can go into Management Studio to restore this database backup. To do that I'll right click on the Databases folder in the Object Explorer window, and choose Restore Database. We're going to pull from a device, so I'll choose that button here, and then come over to the right and click on this ellipsis button. Then I'll press Add, and I'll choose the WideWorldImporters-Full.bak file. I'll say OK, OK again, and then OK one more time. Once it restores successfully, we will have our own fresh copy of Wide World Importers that we can work with. The only other piece of information that'll be helpful to know is the name of the server that you're using. You can find that by clicking on this connect button, and looking at the server name field right here. You'll need to know the server name when it comes time to connect your reports to the database that we just installed.

Contents