search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10k stars 21k forks source link

Missing reference when migrating triggers #122249

Open A7exSchin opened 1 week ago

A7exSchin commented 1 week ago

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

  1. 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.

TPavanBalaji commented 1 week ago

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

TPavanBalaji commented 1 week ago

@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 commented 1 day ago

@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.