• State Not Answered
  • Replies 1 reply
  • Subscribers 14 subscribers
  • Views 1113 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

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

GauravSingh
A Score Level 2

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

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    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

Reply
  • 0
    Certified Lead Developer

    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

Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.