What permission must the user have on source and target on-prem servers for DMA assessment and migrate to work correctly?



  • Link: https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15

    It doesn't say anything on what exact permissions need to be given to the user on the source and target on-prem sql server for the assessment and migration to work correctly?

    Note: For assessment only, target server need not be installed.

    Any reference will be helpful so that I can plan user permission in advance.



  • From the same document, it is mentioned as below:

    Prerequidsite

    https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15#prerequisites

    Not sure, if you needed something else.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2