Does the DMA tool do absolutely no changes on the source sql server?



  • I am planning to use the DMA tool for migrating sql server 2016 to sql server 2019. Both on-prem.

    I will be carrying out a test migration this weekend, followed by deleting the dbs and logins from the target server and re-running the DMA tool next month as the final migration.

    I just wanted some confirmation as to whether the DMA tool does absolutely no changes on the source sql server?



  • Simply running the DMA to gather data will only do that, gather data. It won't affect the underlying data architecture. I haven't used the tool to perform the actual migration, but from everything I understand, that won't affect the original database either.


Log in to reply
 


Suggested Topics

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