Setting up the AdventureWorksLT source database

Supporting Videos

Supporting Documentation

• Microsoft SQL Server Samples

Setting up AdventureWorksLT

The getting started process uses the AdventureWorksLT2012 database as a source system.

This Microsoft sample database is available for download from GitHub:

AdventureWorks releases on GitHub

Download the SQL Server backup file and restore it to the SQL Server engine through Management Studio.

Detailed Steps

1. Download the AdventureWorksLT2012.bak SQL Server database backup file
2. Move it to a location accessible from the database server
3. Use Microsoft SQL Server Management Studio, or a similar tool or script, to restore the database
4. Configure read access for the client account used. The metadata import reads the metadata views from the source.
5. Validate that the database is available from the client