Hi all I added new column to CDT by new version of XSD but getting this error when I tried to move that CSD to other environment

Question

The data store "ISR Data Store" [id=163216, uuid=_a-0000e3b5-3910-8000-9ba5-011c48011c48_35304] will be saved, but will not be published: The data source schema does not match the type mappings: APNX-2-4056-000{Schema-validation: missing column [fundingSource] in table [`ISR_StudyMedicalReview`]} (APNX-2-4053-006 
 
 Here:ISR Data store in Data store object, 
 fundingSource is new column, 
 ISR_StudyMedicalReview is CDT. 
 When I tried to move to another environment during inspection I am getting this error .How can I solve this? 
 
 Thanks

Mike Schmitt · Answer

This error is usually caused by the SQL DB table in the target environment not yet being modified to reflect the new column (as noted in the error message you posted). Can you verify whether the DB in the target environment correctly shows that column already?

Mathieu Drouin · Answer

Did you try publishing the data store? 
 Otherwise, you can try to run the generated SQL script.

Mathieu Drouin · Answer

If you don't want the warning, you need to run the SQL to make the modifications to the DB. You can also publish the Data Store after deploying.

Mike Schmitt · Answer

sireesha said: correct steps for deploying CDT from one environment to other 
 You need to deploy any changes to the table / columns directly to the target environment's Database, and then deploy the updated CDT.