Toad World® Forums

Generating single DDL for multiple workspaces (not all workspaces)

Hi,

Am using TDM V3.5 for modeling and now am in the process of generating DDL scripts for few of the workspaces (to be precise, 3 workspaces out of total 8 workspaces).

Currently TDM allows me to choose a single workspace and so I have 3 different scripts, but the problem is while executing them sequentially, duplicate object errors occur since we have lot of common entities between these workspaces. If we try to remove the Generate DDL option in one workspace, it gets removed in all the workspaces.

So would like to know if there is a way to select multiple workspaces for DDL generation and let TDM handle all the duplicate and dependency issues.

TIA,
Bala