From the course: Implementing a Data Warehouse SQL Server 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Deploy a sample MDS model - SQL Server Tutorial
From the course: Implementing a Data Warehouse SQL Server 2019
Deploy a sample MDS model
- [Instructor] Master Data Services includes sample models and data that you can deploy to your Master Data Database to better understand the product features and capabilities. The three sample model packages are available in the directory on your C drive, underneath Program Files, Microsoft SQL Server, the 150 folder, then Master Data Services, Samples, Packages and you'll find them right here. We have one for product, one for customer and one for chart of accounts. To deploy the sample data, you're going to use a command line application, which you can find back in the Master Data Services folder, underneath Configuration. The executable is MDSModelDeploy.exe. You can find it right here. Now, this is a command line application, so you're not going to run it from right here. What I need to do is open up the Command Prompt tool. So we go down here by Search Box. I'll type in cmd to find the Command Prompt. I also need…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.