From the course: SQL Server Integration Services

Set up the example database - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Set up the example database

“

with the actions that I'm performing in this course, then you'll need to set up you computer to match mine. This isn't a requirement though, to your own databases and server configurations, but I thought it would be helpful to outline how I have my system configured. For this course, you'll need to have two instances of SQL Server installed. I'll be running them on the same machine, but they can be remote servers, as well. As long as you can connect to both of them in SQL Server Management Studio, you'll be fine. I'm currently logged into both instances, as you can see in the object explorer pane. One is the default instance. It's just called MS SQL Server and it's on a computer named Windows 10 dash PC. The second instance has a name, and it's called SQL Server 2019. The first server will have two sample databases added to it. It's these ones right here, Wide World Importers and the Wide World Importers data warehouse. You can get them from Microsoft SQL Server Samples Respository On this page, to Wide World Importer Sample Databases, and inside of here, we'll find two links. One for the Wide World Importers dash full dot B-A-K file, and the second one for the Wide World Importers DW dash full dot B-A-K file. These two databases will give us plenty of data to work with in the course. Once they're downloaded, you're going to move them into the SQL Server backups folder, and you can typically find that on your C drive inside of program files, the folder for Microsoft SQL Server, then the folder that represents your server instance that you want to work with. In my case, it's this one right here, MSSQL Server. Inside of there, you'll go into MSSQL, and then finally into backup. If you get a warning message there, saying that you don't have access to this folder, just press the OK button, and you'll be let in. Then you'll place both of those backup files here. Then, back inside of Management Studio, you can right click on the databases folder in the server, We'll switch to device and then click on the ellipsis button on the far right. We're going to add a new backup media. Then finally, you'll select the files and press OK a couple of times to reinstall them on your system. I've already done that, so I'm going to press cancel a bunch to dismiss all of these windows. That'll place both files here on your database server. The other thing that we need is an empty database to load data into, using Integration Services. I'm going to place that on my second server instance. and choose new database. I'm simply going to give it a name of Kineteco, and press OK. That'll create that new database on the second server instance. That sets up the database server environment. The last thing you'll need are the exercise files for the course. exercise files for the course. You can download them from the course's webpage, You can download them from the course's webpage, and I've placed them here on the desktop and I've placed them here on the desktop for easy access. for easy access. Once you've got everything set up, Once you've got everything set up, you're ready to follow along, as we explore you're ready to follow along, as we explore SQL Server Integration Services. SQL Server Integration Services.

Contents