Skip to main content
Question

Data migration

  • November 6, 2025
  • 4 replies
  • 60 views

Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 175 replies

Hello, it is possible to return data back to the system? I select migration data, but i made mistake and instead of changing something in data, it removes them. 

 

Thanks

4 replies

Forum|alt.badge.img+5
  • Sidekick (Customer)
  • 42 replies
  • November 6, 2025

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


  • Sidekick (Customer)
  • 11 replies
  • November 6, 2025

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


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 175 replies
  • November 11, 2025

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?


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1303 replies
  • November 11, 2025

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