Home

	Expand Search

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 22: Database Creation and Modification

Chapter 22
Database Creation and Modification

About this chapterThis chapter explains how to generate and modify databases using scripts and via ODBC drivers.

Using the ODBC interface

Defining a data source

Configuring a data source

Connecting to a data source

Displaying information about a connected database

Disconnecting from a data source

Accessing a database

Changing target database

Displaying data from a database

Executing SQL queries

Computing database size

Indicating the number of records in a table

Indicating average data type length

Computing database size of a global model

Computing database size of a submodel

Configuring tablespace and storage

Sample tablespace and storage commands

Defining tablespace and storage

Previewing tablespace and storage commands

Customizing scripts

Inserting begin and end scripts for database creation

Inserting begin and end scripts for table creation

Editing a customized script

Formatting variables in customized scripts

Generating a database

Creation parameters for tables, indexes, views, and columns

Database creation parameters

Database modification parameters

Script options and referential integrity options

Defining script options and referential integrity options

Object selection parameters

Generating a database creation script

Creating a database directly

Archiving a WAM

Generating a database modification script

Modifying a database directly

Using test data

Creating a data profile

Test data generation source parameters

Automatic test data generation source parameters

Defining a file as a test data generation source

Defining a list as a test data generation source

Defining an ODBC data source as a test data generation source

Defining column fill parameters

Assigning a data profile

Importing a data profile

Exporting a data profile

Generating test data

Generating a test data script