StrataFrame Forum

Ignore User Defined Columns with a Table

http://forum.strataframe.net/Topic18656.aspx

By Johnny R Smith - 8/21/2008

Can the tool be setup to ignore schema objects (tables, columns, constraints, views, procedures, user defined functions, and/or triggers) added by a customer?  We have customers that add various things to the data structure to extend the functionality of our application and would like to ignore their add-ons and just update our schema.  Can the tool be setup to work this way?
By Dustin Taylor - 8/22/2008

Well, the stored procedures and UDFs will be ignored already, but for the tables themselves, and especially the columns within the tables, no the DDT won't ignore them.

We can ignore the sprocs and udfs by way of an extended property that we put on all StrataFrame items that we can look for. The problem with tables is that there are additional constraints that might change (i.e. foreign key relationships), and that problem grows exponentionally when you start talking about column level changes. For those reasons, we don't plan on accounting for user changes at the table or column level during DDT deployment.

What kind of user customations are your customers doing? There may be a way to enable some level of customization and meet those needs without giving them direct access to the database schema (which is always a bit scary to begin with Wink).