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.