Data Migration Assistant Copy or Move

%3CLINGO-SUB%20id%3D%22lingo-sub-1806111%22%20slang%3D%22en-US%22%3EData%20Migration%20Assistant%20Copy%20or%20Move%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1806111%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20use%20the%20Data%20Migration%20Assistant%20to%20migrate%20db's%20and%20logins%20between%202%20on-premise%20SQL%20servers.%20Everything%20looks%20pretty%20straightforward%20but%20I%20am%20hung%20up%20on%20a%20question%20that%20is%20so%20%22dumb%22%20that%20I%20can't%20seem%20to%20find%20an%20answer%20to.%20Does%20this%20tool%20copy%20the%20databases%20from%20one%20server%20to%20the%20next%20(backup%2Frestore)%20and%20once%20complete%2C%20everything%20on%20the%20source%20server%20remains%20or%20does%20it%20actually%20move%20the%20databases%3F%20Each%20of%20my%204%20brain%20cells%20is%20telling%20me%20that%20the%20source%20data%20will%20remain.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1807045%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Migration%20Assistant%20Copy%20or%20Move%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1807045%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%2C%20the%20DMA%20copy%20the%20source%20database%20to%20the%20destination%2C%20the%20source%20system%20keeps%20unchanged.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I would like to use the Data Migration Assistant to migrate db's and logins between 2 on-premise SQL servers. Everything looks pretty straightforward but I am hung up on a question that is so "dumb" that I can't seem to find an answer to. Does this tool copy the databases from one server to the next (backup/restore) and once complete, everything on the source server remains or does it actually move the databases? Each of my 4 brain cells is telling me that the source data will remain.

1 Reply

 

Right, the DMA copy the source database to the destination, the source system keeps unchanged.