About Migrating Applications Using the Application Repository

[__ __2]

Hi.

Is it possible to include record information in migrating applications using the Application Repository?
The table definition was migrated, but the record information was not migrated, so I'm looking for a way.

[Riya Verma · Accepted solution]

Hi @__ __2 ,

Hope you are doing great.

the Application Repository does not migrate record information. To include record data in the migration, you will need to make some modifications to your migration process.

To include record information in your application migration, you can follow these steps:

1. Create an Import Set table: Define an Import Set table that matches the structure of the target table where you want to migrate the record information.

2. Prepare your data: Format your record information in a compatible format, such as a CSV or Excel file, and ensure that the data aligns with the field mappings of the Import Set table.

3. Load data into the Import Set table: Use the Import Set table's "Load Data" functionality to import your record information into the staging table.

4. Transform and validate data: Once the data is loaded into the Import Set table, you can apply data transformations and validation rules to ensure data quality and compatibility with the target table.

5. Load data into the target table: After the data is transformed and validated, use the "Transform Map" functionality to map the fields from the Import Set table to the corresponding fields in the target table. 

[__ __2]

I understand that the application repository does not migrate record information.
Thank you for your reply.