Previous Topic: Database PropertiesNext Topic: Define SQL Azure Database Roles

Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Database Properties › Define a Database in SQL Azure

Define a Database in SQL Azure

The SQL Azure Database Editor is used to create new databases and define database properties in a SQL Azure physical model.

To define a database in SQL Azure

  1. Click Target - SQL Azure, Databases on the Model menu.

    The SQL Azure Database Editor opens.

  2. Select the database in the Navigation Grid that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new database. Use the Enter filter text box to filter a very large list of databases to quickly locate the one that you want to define.

    Name

    Specifies the name of the database. Change the name of the database in this field.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. Click the General tab and work with the following options:
    EDITION

    Specifies the edition of the database, either Web for Web Edition or Business for Business Edition.

    When EDITION is specified but MAXSIZE is not specified, MAXSIZE will be set to the most restrictive size that the edition supports (1 GB for Web Edition and 10 GB for Business Edition).

    MAXSIZE

    Specifies the maximum size of the database. MAXSIZE must be valid for the specified EDITION.

    Valid values (Web Edition):

    • 1GB
    • 5GB

    Valid values (Business Edition):

    • 10GB
    • 20GB
    • 30GB
    • 40GB
    • 50GB

    Notes:

    • If MAXSIZE is set to a value of 1GB or 5GB, and EDITION is not specified, the database edition is automatically set to Web Edition.
    • If MAXSIZE is set to a value of 10GB, 20GB, 30GB, 40GB, or 50GB, and EDITION is not specified, the database edition is automatically set to Business Edition.
    • If neither MAXSIZE or EDITION are specified, a Web Edition database of size 1GB is created.
  4. (Optional) Click the Where Used tab to view where the database is used in the model.
  5. Click the Permission tab to define the permissions for the database.
  6. (Optional) Click the Comment tab and enter any comments that you want to associate with the database.
  7. (Optional) Click the UDP tab to work with user-defined properties for the database.
  8. (Optional) Click the Notes tab to view history information and view or edit user notes.
  9. Click Close.

    The database is defined and the SQL Azure Database Editor closes.

More information:

View the Where Used Information for a Physical Object

Define Permissions for an Object in a SQL Azure Property Editor

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor

Edit User Notes or View Object History