'AdventureWorks'에 해당되는 글 1건

  1. SQL Server 2012 샘플DB 등록하기


안녕하세요. 주디아줌마입니다.
SQL2012 관련 샘플 DB를 등록해봅시다.^^


※.링크

http://www.mssqltips.com/sqlservertip/2638/attach-sample-database--adventureworks-in-sql-server-2012/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=2012513


※.다운로드 
AdventureWorks2012_Data.mdf for case-insensitive collation
AdventureWorks2012CSData.mdf for case-sensitive collation 


CREATE DATABASE AdventureWorks2012_Data
ON (FILENAME = N'E:\SQLData\AdventureWorks2012_Data.mdf')
FOR ATTACH_REBUILD_LOG 
Go


추가 테스트 환경 설정

※. 테스트를 위해서 adventureworks db를 크게 만드는 script.. by adam download
http://sqlblog.com/blogs/adam_machanic/archive/2011/10/17/thinking-big-adventure.aspx

※. Enlarging the AdventureWorks Sample Databases - Jonathan Kehayias
http://www.sqlskills.com/blogs/jonathan/enlarging-the-adventureworks-sample-databases/

※. Adventureworks2012, Adventureworks2012DW, pubs, Northwind
http://www.sqlpanda.com/2013/09/sql-server-2012-sample-database.html