Ignore User Defined Columns with a Table


Author
Message
Johnny R Smith
Johnny R Smith
StrataFrame Beginner (6 reputation)StrataFrame Beginner (6 reputation)StrataFrame Beginner (6 reputation)StrataFrame Beginner (6 reputation)StrataFrame Beginner (6 reputation)StrataFrame Beginner (6 reputation)StrataFrame Beginner (6 reputation)StrataFrame Beginner (6 reputation)StrataFrame Beginner (6 reputation)
Group: Forum Members
Posts: 2, Visits: 9
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?
Dustin Taylor
Dustin Taylor
StrataFrame Team Member (664 reputation)
Group: StrataFrame Users
Posts: 364, Visits: 771
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).

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search