Share via

How to: Install the PatternApplication Sample

  • Article

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

This topic explains how to install the PatternApplication sample into the SQL Server Modeling Services database. The PatternApplication sample provides a convenient method for applying common Modeling Services patterns to other models that are written with Microsoft code name “M”. For more information about these common Modeling Services patterns, see SQL Server Modeling Services Patterns.

In this topic, you will perform the following tasks:

  • Compile the PatternApplication sample code into an image file.

  • Load the PatternApplication image file into the Modeling Services database.

To compile the PatternApplication sample into an image file.

  1. Download and extract the PatternApplication sample files by clicking this link.

  2. On the Start Menu, click All Programs, Microsoft SQL Server Modeling CTP, and open the Microsoft SQL Server Modeling CTP Command Prompt.

  3. Navigate to the directory that contains the PatternApplication sample files.

  4. Use the msbuild.exe tool to build the PatternApplication.csproj project.

    msbuild PatternApplication.csproj

To load the PatternApplication.mx image file into the SQL Server Modeling Services database.

  1. At the same Oslo Command Prompt, navigate to the bin/Debug directory for the PatternApplication sample.

  2. Run the following command to load the image file into the Modeling Services database.

    mx.exe install PatternApplication.mx /database:Repository

    Note

    Note that the previous command uses the database parameter to target a Modeling Services database named Repository. If your Modeling Services database has a different name, use that name instead.

    Note

    You may see a warning, M6046, that states that the database collation is unexpected. You can safely ignore this warning, because it does not prevent the sample from installing correctly.

See Also

Concepts

Using the PatternApplication Sample
SQL Server Modeling Services Patterns