Share via

Does DMA for SQL keep the source database intact?

Libby Gregg 20 Reputation points
2024-06-19T18:30:55.2966667+00:00

I want to run DMA on a 2022 SQL Server. I want to migrate databases currently existing on a 2008R2 SQL server.

2 questions:

If migrated successfully, will the source database remain intact and functional?

and

Is there a way to only migrate one database at a time? The source SQL server has 25 databases

but I only want to transfer 1 to my test environment. I did edit the dma.exe.config file and set parallel

processing to 1.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,116 questions
0 comments
Accepted answer
  1. LiHongMSFT-4306 24,931 Reputation points
    2024-06-20T02:40:50.5333333+00:00

    Hi @Libby Gregg

    If migrated successfully, will the source database remain intact and functional?

    Yes, the source database is still intact.

    Is there a way to only migrate one database at a time?

    You could choose the specific databases that you want to migrate by only selecting those databases, in the left pane of the Add databases page.

    See this tech doc.

    Best regards,

    Cosmog Hong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest