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')

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