Marko Apfel - Afghanistan/Belgium/Germany

Management, Architecture, Programming, QA, Coach, GIS, EAI

  Home  |   Contact  |   Syndication    |   Login
  169 Posts | 2 Stories | 138 Comments | 4 Trackbacks

News



Twitter | LinkedIn | Xing

Article Categories

Archives

Post Categories

BizTalk

C#

Enterprise Library

SAP

SQL Server

Technologie

Sunday, October 21, 2012 #

Problem

If you run the “Generate database from model” wizard and execute the generated script the destination database could be the wrong one (for instance master of the SQL Server).

Solution

To use an own mdf attachable user database some connection information must specified during script execution.

Execute your script opens the dialog “Connect to Server”.

image

Press “Options” and go to the second tab “Connection Properties”.

Select “Browse server” in the “Connect to database” dropdown box:

image

Confirm the information dialog with “Yes”.

In the following dialog you could choose your user database.

image

Now the schema is created in the user database.