Share via

Updating Models in the Database (SQL Server Modeling CTP)

  • 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.]

When you develop a data-driven application, you might need to iterate the data model and the code that uses the data model. In order to test the data model, the current version of the schema must be loaded into the database. As the application evolves, the data model evolves to support new features and fixes.

With you use the Microsoft code name “M” language to write your model, you deploy the model to the database by using either Visual Studio 2010 or the command-line tool, Mx.exe. The topics in this section describe various strategies for updating the database representation of the model with both of these tools.

In This Section

  1. How to: Update an Existing Model Using Visual Studio

  2. How to: Update an Existing Model Using the -force Option of Mx.exe

  3. How to: Update an Existing Model by Recreating the SQL Server Modeling Services Database

See Also

Concepts

Designing Models and Applications in Parallel
Modeling Process