Share via

Deploy Domains to the Database

  • 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 is the third step in the Getting Started with SQL Server Modeling CTP and Visual Studio 2010 tutorial. The preceding step is Add Schemas to a Domain. The following step is Develop Using Generated Entity Framework Classes.

In this task, you configure your local server to store the Dinner and RSVP data. You also create a NerdDinner database to hold the Dinners and RSVPs tables.

Configure the database connection string

  1. On the Project menu, click MiniNerdDinner Properties.

  2. Select the M Deployment tab.

  3. Click the button next to the Database Connection String field to configure the connection string.

  4. In the Connection Properties dialog box, enter your local instance of SQL Server 2008 and type NerdDinner for the database name.

    Tip

    If you are using SQL Server 2008 Express, enter “.<EM>SqlExpressName” where SqlExpressName is the name of the SQL Server 2008 Express instance.

  5. Click the Test Connection button.

  6. If successful, click OK. In the ensuing dialog, click Yes to create the NerdDinner database.

Deploy to the database

  1. In Solution Explorer, right-click the MiniNerdDinner project and click Deploy.

  2. On the View menu, click Output to verify that the deployment succeeded.

    Note

    In the current release, when a SQL Server Modeling CTP project is manually or automatically deployed using F5 in Visual Studio 2010, only the selected project is deployed -- referenced projects are not deployed. Any referenced projects must be deployed by the user prior to deploying the current project.

  3. On the View menu, click Server Explorer and navigate to the NerdDinner database. Confirm that the Dinners and RVSP tables exist.

See Also

Concepts

Getting Started with SQL Server Modeling CTP and Visual Studio 2010