Triggers migration

[pandvan]

We're trying to downgrade a Magento 2.4.5-p5 EE instance from Magento Clud to a CE on-prem using script included in this repo.
We noted that many triggers are using row_id column and so it's not possible to import the DB once "fixed" by scripts.
How do you manage those triggers? Just drop them on export?
We noted that a setup:install will recreate them, even if less than they originally were.

[thomas-kl1]

Hello @pandvan

You should ignore these triggers. I'm not sure why you run setup:install, however you should do:

• Export ACC database
• Import dump the into your new env with your Magento Open Source instance (that means no you don't have any adobe commerce modules)
• Run the scripts from this repo
• Run the setup:upgrade command