Skip to main content
rohity0003
Known Participant
Sep 11, 2023 3:26 PM UTC
Question

DB Migration tactics

Hello,  We are testing the waters for a DB migration.  ( MySQL to Amazon RDS ).  Within one of our environments, we plan to make a copy of our existing apps, and point the copies to the new DB for testing purposes.  

We realized this would entail updated all object references for the copied objects, which is labor intensive.  Is there a tool tailored for this scenario, or a better approach we could try?

Thanks.

4 replies

stefanhelzle0001
Brainy
Sep 11, 2023 4:00 PM UTC

What do you mean with "We realized this would entail updated all object references for the copied objects"?

rohity0003
Known Participant
Sep 15, 2023 4:57 PM UTC

If we make a copy of our application, to point to the new DB, while leaving the original intact. (In the same environment)

mathieud0001
Genius
Sep 11, 2023 11:44 PM UTC

I'm not aware of a better approach. There is no easy way to duplicate an app in Appian.

rohity0003
Known Participant
Sep 19, 2023 1:30 PM UTC

Thanks for the confirmation Mathieu.