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

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?

Did you try publishing the data store?

Otherwise, you can try to run the generated SQL script.

Yes I published Data store a well.But still getting same error.

Is there any way to solve that

in the source environment I have made changes to CDT.So in the Target environment those updated column is not yet updated. So for that only I am deploying from source.

IF possible, can you please explain me the correct steps for deploying CDT from  one environment to other?

Can you post the contents of the XSD file and also the structure of the table in the database?

Hi Mathieu,thanks for the reply if possible can you share me the correct steps to deploy CDT from one environment to other?

Usually just have to push and then publish the Data Store in the target environment.

I'm assuming there's a naming mismatch for the column but can't really tell without more information.

Okay I will explain you the total scenerio I have added one column to the CDT by new version of XSD in one environment.I haven't done anything in the Target environment so while deploying this modified CDT to target environment I am getting the above error.Do I need to do anything in target environment before deploying?

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.

I have to run the alter SQL in target environment right to remove that warning?