DSXchange

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?

What is the purpose of SQL Server Enterprise Property Init.sql and when is it needed and when can it be omitted?

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.