Best approach for database updates/backfilling historical records in Nextworld?

Nextworld Platform How Tos
1

What is the recommended way to run a database update in Nextworld?

For example, I’ve added a new column to a table and need to populate it for all existing/historical records. I’d like to avoid triggering table triggers during the update, and I also want to avoid issues such as “Invalid Lookup Value” errors when updating historical data.

Is there a recommended approach in Nextworld for handling these types of data migrations/backfills?

Does Nextworld have anything similar to Liquibase scripts or a migration framework where we can safely run one-time database update scripts against existing records?

Any best practices or examples would be greatly appreciated.

2

What it sounds to me like you’re looking for is to run a data transform with potentially a Bulk Update action in it. Per Nextworld Help, Data transforms execute without any of the typical integrity checks that protect data, so use data transforms sparingly which sounds like the type of behavior you’re seeking.

See Data Transforms in Nextworld Help for more details. I’d definitely consider engaging with the Nextworld Customer Support team if you haven’t previously executed one of these.