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

saileshd over 7 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 jaishankarj over 7 years ago

I will agree with gaurava322.

1. If there is no data in table you can:

Drop the table in MySql and then change the XSD of the CDT with proper annotation for the column and table name. Verify the entity and will create the table.

2. If there is data in table:

Create a temp table and move the data from the main table to it. Delete all the rows from the main table and alter the column definition. Move the data back from temp table and deop the temp table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 jaishankarj over 7 years ago

I will agree with gaurava322.

1. If there is no data in table you can:

Drop the table in MySql and then change the XSD of the CDT with proper annotation for the column and table name. Verify the entity and will create the table.

2. If there is data in table:

Create a temp table and move the data from the main table to it. Delete all the rows from the main table and alter the column definition. Move the data back from temp table and deop the temp table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data