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

judym598

Certified Senior Developer

over 10 years ago

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 ...

Discussion posts and replies are publicly visible

Parents

0 Mike Cichy
Appian Employee
over 10 years ago

CDTs should be abstracted away from such low level DB information. You should not have to update your CDTs at all, just run the new db scripts.
What you may have to update, is any validation rules on forms and in process that rely on DB limits. Are you relaxing the DB restrictions or making them stricter?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Cichy
Appian Employee
over 10 years ago

CDTs should be abstracted away from such low level DB information. You should not have to update your CDTs at all, just run the new db scripts.
What you may have to update, is any validation rules on forms and in process that rely on DB limits. Are you relaxing the DB restrictions or making them stricter?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data