Skip to main content
G
gauravs0010
Inspiring
February 22, 2023
Question

Migrating data from Oracle on-premise to Appian Cloud Maria DB

  • February 22, 2023
  • 1 reply
  • 0 views

Hi Experts,

Our client have a specific requirement for which we need to migrate all the data from Oracle on Premise database to the Appian Cloud Database i.e Maria DB.
What all are the step involved for the effective data migration.

Note: Tables are yet not created in the Cloud database.

Thanks,

Gaurav Singh

1 reply

srinivast0001
srinivast0001
March 16, 2023

Hi Gaurav,

Step 1: export all the DDL from oracle on premise. convert the DDL which can be suitable for cloud database this can be done manually or some third party tools which can be supportive for conversion and import into cloud database (note party tools are not full functional for convention it has some limitations)

Step 2: Once the tables are created. take the export of DML and verify the structure and import the data.

while preparing the migration scripts you can refer to Appian playbook for database best practices.

Thanks & Regards,
Srinivas Thota

    Terms & ConditionsAccessibility statement