Hi all,
I've managed to configure AWS RDS SqlServer Data source in our Appian dev env application.
Current dev environment is running on vmware private cloud with Sql Server data source.
Could someone please suggest the procedure/steps how to replace current data source with RDS Sql Server?
Do we need to modify each DSE objects OR any recommended systematic approach to achieve this?
What are the objects that we need to check other than DSE please?
Can we update the application module by module basis? (i.e. Part of the application/functions will retain the current/existing data source, some of the specific modules will can use AWS RDS source? )
It would be helpful if someone can shed the light on any available whitepapers/ case studies resource and share the details of known challenges for this use case please. - Thanks.
Discussion posts and replies are publicly visible
AFAIK Appian uses the configured data source name to identify the DB in data store objects. When you create a new data source in the admin console and update all data stores to use this one, you should be good to go. After you did all the DB related migration steps that is.
Thanks Steve, I'll try this approach.