Hello, We have a requirement in our running project that we need to migrate our database(MariaDB on-premise) to MySQL on-premise DB. Currently in our applications we are using CDTs and records and my concerns are- In Appian system, what are the changes we need to do? Is there any impact on existing filters, summary views, and etc. if we change the source of the records? Any impact on existing DSE object? Can you please suggest the impact on any other artifacts in Appian? Thanks!

Database migration from MariaDB on-premise to MySQL on-premise

mohits1040

Certified Lead Developer

9 months ago

Hello,

We have a requirement in our running project that we need to migrate our database(MariaDB on-premise) to MySQL on-premise DB.
Currently in our applications we are using CDTs and records and my concerns are-

In Appian system, what are the changes we need to do?
Is there any impact on existing filters, summary views, and etc. if we change the source of the records?
Any impact on existing DSE object?
Can you please suggest the impact on any other artifacts in Appian?

Thanks!

Discussion posts and replies are publicly visible

Top Replies

Srinivas 9 months ago +1
Certified Senior Developer

Update Appian's data sources to point to the new MySQL database. Check and adjust Custom Data Types (CDTs) for any compatibility issues with MySQL. Redirect Appian Record Types to fetch data from MySQL…

Parents

0 venkat Avuluri
Certified Senior Developer
9 months ago

mohits1040 said:
Is there any impact on existing filters, summary views, and etc. if we change the source of the records?

Record connections gonna break and all objects that have record references gonna through an error , Alternative is Create new records with new source and slowly replace the older references.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkat Avuluri
Certified Senior Developer
9 months ago

mohits1040 said:
Is there any impact on existing filters, summary views, and etc. if we change the source of the records?

Record connections gonna break and all objects that have record references gonna through an error , Alternative is Create new records with new source and slowly replace the older references.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data