Microsoft SQL Server Reporting Services(SSRS)를 익히기 위해서 MS에서 제공하는 샘플 데이터베이스(Adventureworks2012)와 샘플 보고서입니다.

* 샘플 데이터베이스: http://msftdbprodsamples.codeplex.com/releases/view/55330

* AdventureWorks 2012 SSRS Samples: http://advworks2012sssrs.codeplex.com/

* 설치 방법

  1. Download the AdventureWorks2012 Data File .
  2. From the License Agreement, click I Agree.

  3. From File Download, click Save and browse to a location on your local server.

  4. From SQL Server Management Studio, execute the following code:

    Case-insensitive Database

    CREATE DATABASE AdventureWorks2012 
    ON (FILENAME = '{drive}:\{file path}\AdventureWorks2012_Data.mdf') 
    FOR ATTACH_REBUILD_LOG;
    

    Case-sensitive Database

     
    CREATE DATABASE AdventureWorks2012_CS 
    ON (FILENAME = '{drive}:\{file path}\AdventureWorks2012_CS_Data.mdf') 
    FOR ATTACH_REBUILD_LOG; 
    

     

신고




Posted by 금붕어70
TAG