Question : 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 […]
Tag: sql-server-data-migration-assistant
Does the DMA tool do absolutely no changes on the source sql server?
Question : I am planning to use the DMA tool for migrating sql server 2016 to sql server 2019. Both […]
How to ensure that the source database cannot be modified when using the DMA’s migrate option?
Question : I am performing a database migration (onprem sql 2016 to onprem sql 2019) using the DMA tool. The […]
How to do minimum downtime migration using DMA?
Question : I’m using DMA to migrate sql server from source server to target server (on-prem). After completing the migrate […]
Does the DMA tool support an online migration for on-prem source and on-prem target?
Question : I a planning to use the DMA tool to make a test migration from an on-prem source sql […]
What are untrusted constraints and what action needs taken to rectify?
Question : Link: https://docs.microsoft.com/en-us/sql/dma/dma-bestpractices?view=sql-server-ver15 Check for untrusted constraints on both the source database and the target database before migrating data. […]