網頁

2012年4月25日 星期三

Install Northwind database on SQL Server 2008 R2

I have a lab for testing Bulk Insert Task in SSIS. According to this example, it need to access Northwind Database.
Due to my environment is SQL Server 2008 R2,it has already never exist this naming database since SQL Server 2005. So I want to know whether is can install Northwind sample database on SQL Server 2008 R2.

I search this database from Microsoft Website and find where it can be downloaded from
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23654
ScreenHunter_04 Apr. 25 14.30After download,extract and execute “SQL2000SampleDB.msi” by following the wizard, the extracted files will be put on “C:\SQL Server 2000 Sample Database”.ScreenHunter_05 Apr. 25 14.42For quickly complete this job, I will copy “Northwind.MDF” & “Northwind.LDF” to the SQL Server default database file location as “C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA”
ScreenHunter_06 Apr. 25 14.44Open Microsoft SQL Server Management Studio and Right-Click Database, select “Attach” item in menu so that Attach Databases windows will show up now.
ScreenHunter_07 Apr. 25 14.49In Attach Database window,click “Add” button, select “Northwind.MDF” next to click “OK” button to complete this selection.
ScreenHunter_09 Apr. 25 15.05So does that the Northwind database will be mounted and online now.
ScreenHunter_11 Apr. 25 15.14

沒有留言:

張貼留言

Since 2010 Design by Davidwa
©Copyright Davidwa Inc. All rights reserved.