Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
8 subscribers
Views
1524 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
#Best Practice for promoting DataStore updates: How do we handle this
senthilar
over 10 years ago
#Best Practice for promoting DataStore updates:
How do we handle this scenario -
we have a main CDT in our application. An Entity and DataStore are created for this CDT. Now, this CDT structure changes. We manually drop the tables and sequences (using SQL Developer) and then publish the DataStore again. This is fine for Dev environment.
Now, how do we promote this DataStore to QA? Do we have to manually drop all tables and sequences and then import DataStore and then Publish them? This will result in all data getting wiped out. Is there a way to do this more straight-forward?
...
OriginalPostID-118773
OriginalPostID-118773
Discussion posts and replies are publicly visible
Parents
0
siddharthg521
over 10 years ago
I am not sure why do you want to drop the entire table? If your CDT structure has changed - let's say changing the data type of one column, then you can execute the necessary SQL query to update that column data type in the database and once done, you go and re- publish your modified CDT to the same data store, it will verify the mappings successfully and you will be able to publish the change.
Therefore, now to move it to QA, before deploying the data store package, run the sql command successfully in the database and then inspect/import your package and your database and CDT will reflect the latest state and will be in sync without actually dropping the entire table.
If this does not answer your problem, could you please tell what exactly your use case is or what are you eaxtly changing in your CDT?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
siddharthg521
over 10 years ago
I am not sure why do you want to drop the entire table? If your CDT structure has changed - let's say changing the data type of one column, then you can execute the necessary SQL query to update that column data type in the database and once done, you go and re- publish your modified CDT to the same data store, it will verify the mappings successfully and you will be able to publish the change.
Therefore, now to move it to QA, before deploying the data store package, run the sql command successfully in the database and then inspect/import your package and your database and CDT will reflect the latest state and will be in sync without actually dropping the entire table.
If this does not answer your problem, could you please tell what exactly your use case is or what are you eaxtly changing in your CDT?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data