Nov 11, 2015

AdventureWorks Database for SQL Server 2012

AdventureWorks Sample Database for SQL Server 2012 can be downloaded from CodePlex site using below link.

Download AdventureWorks2012 Data File (Case Sensitive)

The data file name is AdventureWorks2012_CS_Data.mdf as the collation of database is case sensitive.

you can download case insensitive version from the below link:

Download AdventureWorks2012 Data File (Case Insensitive)

Once the data file is downloaded, run below script to attach the downloaded AdventureWorks Data File to SQL Server 2012
CREATE DATABASE AdventureWorks2012
ON (FILENAME = 'D:\SampleDatabases\AdventureWorks2012_CS_Data.mdf')
FOR ATTACH_REBUILD_LOG ;

In the script change, you need to change your path in FILENAME where you have placed the AdventureWorks Data File.

    Choose :
  • OR
  • To comment
No comments:
Write comments

Software developers who need to create installer files for their applications can choose Windows Installer, Inno Setup, Actual Installer, and others.