How to: Install the PatternApplication Sample
[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.
Download and extract the
PatternApplication
sample files by clicking this link.On the Start Menu, click All Programs, Microsoft SQL Server Modeling CTP, and open the Microsoft SQL Server Modeling CTP Command Prompt.
Navigate to the directory that contains the
PatternApplication
sample files.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.
At the same Oslo Command Prompt, navigate to the bin/Debug directory for the PatternApplication sample.
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