We have to make some changes to the structure of several related tables in our M

Certified Senior Developer
We have to make some changes to the structure of several related tables in our MySQL DB in our production environment (i.e., change the character length of a column). These tables are associated with CDTs that are used in a number of process models and rules. What's the best way to make these changes to avoid 'breaking' our process models and rules. Does this make sense?

1. Update the table structures first.
2. Republish each of the related data types (CDTs)
3. Run Impact Analysis and follow steps to update process models
4. Re-verify Data Store (?)
5. Export updated DS, CDTs (which technically shouldn't have changed since the column and data type is the same), PMs, rules, etc.
6. When importing the updated DS, CDTs, PMs, rules, etc. - Run the data scripts that will update the table structures FIRST.

Please advise if I have any of these steps out of order or if I'm missing any (such as - do I need to delete the CDTand reimport the XSD file ...

OriginalPostID-141861

OriginalPostID-141861

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    That's good to know - I was hoping I wouldn't have to worry too much about the CDTs. We have a key table with this particular column that has a length of '6' that is related to others with the same column but the length is 10 or 20 characters - we're going to make them all '6'. Right now there are no validation rules on the forms used to capture this data which is why we found out we needed to fix it. We'll be adding them now. Thanks Mike!
Reply
  • 0
    Certified Senior Developer
    That's good to know - I was hoping I wouldn't have to worry too much about the CDTs. We have a key table with this particular column that has a length of '6' that is related to others with the same column but the length is 10 or 20 characters - we're going to make them all '6'. Right now there are no validation rules on the forms used to capture this data which is why we found out we needed to fix it. We'll be adding them now. Thanks Mike!
Children
No Data