Question
How to deploy schema changes to other environments?
Hi All,
I want to deploy schema changes to other environments without running scripts.
Are there any steps to deploy the schema changes through the Product file?
Please explain.
Regards,
AK
***Edited by Moderator: Lochan to update platform capability tags***
Accepted Solution
Knowledge Expert
FR
Just include database table (DATA-ADMIN-DB-TABLE) rule
Areteans Technology Solutions
GB
Yes. Do I need to include the DB instance of that particular table?
Or what else I need to include in the Product rule.
Example scenario,
I have exposed the one column(ex: First Name) in my work table.
How to deploy this change to my testing environment.
Regards,
AK
Coforge DPA
GB
Hi
As mentioned in comments above include the Data-Admin-Db table and class instance in your product.
While importing the product in test environment , it will give you an option to execute the db changes. If your user id has access to run the sql, you can continue and it will add the new column.
If you cant do it via Developer portal, then run the Update query in the db separately and import the Product .
Regards
Bhavya