Build scripts [RazzaDS]

Infosphere Master Data Management theory and best practices

Moderators: chulett, rschirm, falsehate

Post Reply
datastage
Participant
Posts: 229
Joined: Wed Oct 23, 2002 10:10 am
Location: Omaha

Build scripts [RazzaDS]

Post by datastage »

I'm trying to understand the difference between the 'SQL Server Build - No Constraints.sql' and 'SQL Server Build Constraints.sql' scripts and their relation to the main build script 'SQL Server Build.sql'

Is it as simple as Build.sql is a combination of both, and No Constraints.sql is what you would execute if you wanted the database without all the indexes, keys, integrity, and triggers that were absolutely necessary? And then Build Constraints.sql is what adds what was left off in case wanted at a later date?
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.

"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
datastage
Participant
Posts: 229
Joined: Wed Oct 23, 2002 10:10 am
Location: Omaha

Post by datastage »

What is the purpose of SQL Server Enterprise Property Init.sql and when is it needed and when can it be omitted?
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.

"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
falsehate
Participant
Posts: 9
Joined: Tue Mar 16, 2004 12:06 am

Post by falsehate »

This is a template for some 'canned' properties to support Hyperion Enterprise. If you run the script it will create the property categories and the properties. These are really only useful if the Enterprise export class was purchased and activated.
Post Reply