6. Meta data

Object tree

Server->Database->Schema->Table or view->Column

Tables:

• dbo.Obj
• dbo.Col_hist
• dbo.Obj_dep
• static.Column_type
• static.Object_type
• static.Server_type

Views:

• dbo.Obj_ext
• dbo.Col_ext
• dbo.Col
• dbo.Obj

Procedures:

• dbo.info
• dbo.refresh

Properties

Properties that are related to objects in the object tree and can be easily adjusted by calling betl.dbo.setp and betl.dbo.getp. Properties use inheritance. For example the property recreate_tables will enable the dropping of target tables (handy during development). If you set this property on a database level, it will apply to all schemas and tables in this database.

A property can be related to a database object or a user ( this is called property scope).

• db_object: this property relates to a database object ( server, database, schema, table or view).
• user : this property is related to a specific sql server user ( e.g. exec_sql, log_level, nesting).

Examples:

exec betl.dbo.setp 'log_level', debug  -- show extra logging in messages pane
exec betl.dbo.setp 'exec_sql', 0  -- do not execute any sql via BETL, but instead print it. 
exec betl.dbo.setp 'recreate_tables', 1 , 'AW_Staging'  -- every table in AW_Staging will be recreated every time
exec betl.dbo.setp 'template_id', 1, '[AdventureWorks2014]' -- template 1 is simple truncate insert for all tables and views in AdventureWorks2014
exec betl.dbo.info 

Tables:

• dbo.Property
• dbo.Property_value
• static.Property
• static.Template
• static.Log_level

Views:

• dbo.prop_ext
• dbo.prop

Procedures:

• dbo.info
• dbo.getp
• dbo.setp