Data migration

If the data has been deleted from the table and the table hasn't been archived or backed up, then no.

Using a migration job to remove data is similar to performing a DELETE operation on the table and then committing the changes, or deleting the data directly from an Aurena screen

Little chance, you can try "AS OF TIMESTAP", but later than 1-2 back from the event will not work.

In “source name”, add “as of timestamp…” (procedure base on MIGRATE_SOURCE_DATA)

Example

Instead of

SALES_PART_TAB A

type

SALES_PART_TAB  AS OF TIMESTAMP TO_TIMESTAMP('2025-11-05 09:30:00', 'YYYY-MM-DD HH:MI:SS') A

I run data migration, it has written that data migration runs successfully, but nothing changes. I want to add number in column actual_revision in view construction items, but nothing happen. Is this because I removed ROWID from data migration?

​@Ed22 can you share some screenshots of your mig job? And explain exactly what you try to do.

Hello, I want to change IN view ENG_PART_MASTER_MAIN value of some column, but nothing happen. For example part_no has firstrevision 01, I want to change it to the 00 or any number through migrate_source_data or excel_migration, but without any change

Through excel I can add new part_no to the view, but I cant change anything

Because during creating new part_no I can also update new value in column first_revision, but I want to change it at once.

Thanks

Migrate_source_data

We have two steps

1. ENG_PART_MASTER_MAIN
2. ENG_PART_REVISION

Engineering Part

Engineering Part Revisions

 

They are not dependent views, for example part_no M000401 I have only on ENG_PART_MASTER_MAIN and not in ENG_PART_REVISION and I want change it only in ENG_PART_MASTER_MAIN, but its not possible

In the ENG_PART_MASTER_MAIN view, the first_revision field is defined as:
 Eng_Part_Revision_API.Get_Last_Rev(epm.part_no).

This is a read-only field.

The function returns  part_rev for the largest of rev_no (for part_no) from table eng_part_revision_tab