Missing reference when migrating triggers

[A7exSchin]

Hi!

We had an issue using DMS which also is supposed to migrate all triggers (because sometimes it does it, and sometimes it doesn't). I found this page and in the Prerequisites it states

If migrating triggers, user must have the “TRIGGER” privilege on the source and target server.

We made sure both users have the required permissions.
Additionally, in the Post Migration activities it states

2. Recreate all the triggers on the target database as extracted during the pre-migration step.

There was no step where we extracted the triggers? Something is missing

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: b14c5b08-b543-b9d5-88f5-bfe846bd57d4
• Version Independent ID: 4004d227-1c90-e4ec-4c14-77a6db6c8a75
• Content: Tutorial: Migrate MySQL to Azure Database for MySQL offline using DMS - Azure Database Migration Service
• Content Source: articles/dms/tutorial-mysql-azure-mysql-offline-portal.md
• Service: dms
• GitHub Login: @KarlaEscobar
• Microsoft Alias: karlaescobar

[TPavanBalaji]

@A7exSchin
Thanks for your feedback! We will investigate and update as appropriate.

[TPavanBalaji]

@A7exSchin
Thank you for bringing this to our attention.
I've delegated this to content author, who will review it and offer their insightful opinions.

[A7exSchin]

@TPavanBalaji

Thanks!

I also figured out our problem: Nowhere does this article mention, that the triggers will be removed if you start a replication. I see that this is an article for the Migration tutorial, but maybe replication is wanted in conjunction with that.