Modify Type for a field in CDT as well as in MySQL

saileshd over 8 years ago

I modified type of a field in CDT from int(11) to VARCHAR(255) and wanted to change the same in MySQL. But somehow I am not able to verify my Datasore. Can anyone direct me to best practices on this end?

Discussion posts and replies are publicly visible

Parents

0 gaurava322 over 8 years ago

If the DB table has data in it, then following is the practice that should be made:
1) Create a backup table, copy all the data from the main table to backup table.
2) delete all records from the main table
3) alter the table column to varchar(255)
4) Now Insert all the data from backup table to main table.

5) Now go in Appian, under Data types, open the cdt corresponding to the table and hit "Create new version from XSD". Once this is updated, check outdated dependents.

You are all set.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 gaurava322 over 8 years ago

If the DB table has data in it, then following is the practice that should be made:
1) Create a backup table, copy all the data from the main table to backup table.
2) delete all records from the main table
3) alter the table column to varchar(255)
4) Now Insert all the data from backup table to main table.

5) Now go in Appian, under Data types, open the cdt corresponding to the table and hit "Create new version from XSD". Once this is updated, check outdated dependents.

You are all set.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data