AdventureWorksLT is no longer available

Question

It seems the LT version is no longer available.  The 2012 won't work with 2008R2Express due to version differences. 705 vs 661.

Where can I get the LT version?

Also, the documentation for the installation of the 2008R2 version points to the 2012 version.

Answer 1

have you tried the script based version ?

http://awlt2008dbscript.codeplex.com/

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Hello,

Thanks Daniel for responding to this thread.

We uploaded an AdventureWorksLT 2008R2 database installation script to http://msftdbprodsamples.codeplex.com/releases/view/59211.

Follow these steps to install the sample database from the script:

1. Download  AdventureWorks 2008 R2 LT Script.zip (http://msftdbprodsamples.codeplex.com/downloads/get/382279) or AdventureWorks 2012 LT Script.zip  (http://msftdbprodsamples.codeplex.com/downloads/get/373779).
2. Copy the DDL script files to any path.
3. Open {Script Files Path}\instawdb.sql in SQL Server Management Studio.
4. Update the script path variables.
5. If necessary, change the :setvar SqlSamplesDatabasePath variable to your SQL Server 2012 or SQL Server 2008 R2 path.
6. Note The default SQL Server Express 2008R2 path is C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\. The default SQL Server 2012 path is C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\.
7. Change the :setvar SqlSamplesSourceDataPath variable to the path containing the .csv files.
8. Uncomment each :setvar variable.
9. On the Query menu, click SQLCMD Mode.
10. On the Standard toolbar, click the Execute button to run the script.

We also updated the AdventureWorks 2012 LT Script.zip file with a script version that is not dependent on the full AdventureWorks 2012 database.

We value your feedback on the process of creating SQL Server samples that reflect your needs.

When you see answers and helpful posts, please click Vote As Helpful,Propose As Answer, and/orMark As Answer