Hello,
we have a locally hosted production environment and a cloud development environment. We want to deploy the application from the cloud to the local machine. When we export in dev and import the app to prod environment the database tables are understandably not linked to the record types. However when I connect them and tell Appian where they are (I am running a local MariaDb and connected it to Appian via admin console) they are connected up until I import another version of the application. So on each import I have to go through each record type and add the data source which is the database table. How to solve this? There has to be a better way to do this.
Discussion posts and replies are publicly visible
How do you connect to the DB? Is that set up in admin console? If yes, I think that the names of the data sources must be equal.
A better idea might be to use a connected system to create the DB connection.
Yes it is set up in the admin console. But the development environment uses the default cloud database and the data sources list in admin console is empty. So I can set up the production data source to any name I want but the cloud data source doesn't have any name.Regarding the DB connection, I have to somehow create a new database in the cloud instance (to mimic the setup I have locally) but I don't have access to the system where all of this runs.
Yeah, I would recommend creating a new schema, copying the database over and creating a connected system that points to that new schema. Your imports should work fine after that.
Otherwise, you could also try naming your Data Source on your on-prem instance the same name as the cloud instance name?