Object Components

These are components such as tables, views, triggers, functions, stored procedures. The scripts generated allow you version control the code and includes features such as permissions.

Example Component Template

<?xml version="1.0" encoding="utf-8"?>
<ObjectComponent Schema="${schema}" Category="functions" Name="${filename}">
  <Option Name="Permissions" Value="True"/>
  <SchemaObject Name="${name}" Type="Function"/>
  <DynamicQuery>
    <![CDATA[       
        select OBJECT_SCHEMA_NAME(fct.id) as '${schema}',
        '[' + LOWER(OBJECT_SCHEMA_NAME(fct.id)) + '].[' + [fct].[name]  + ']' as '${filename}',
        [fct].[name] as '${name}'
        FROM sysobjects [fct]
        where type IN (N'FN', N'IF', N'TF', N'FS', N'FT')
        and [fct].[name] not in ('fn_diagramobjects')
    ]]> 
  </DynamicQuery>
  <Deployment Weight="200"/>
</ObjectComponent>