Best tool and technique to perform the Sql server to sql server migration.

Question

Best tool and technique to perform the Sql server to sql server migration.

Rahul 251

Please inform the best tool / method to perform the data migration and other database assets migration from one sql server to the another sql server.

It should be able to migrate all the attributes of the sql server and sql server database like login, database users , stored procedure etc.

LiHongMSFT-4306 31,576 Reputation points

2023-11-30T02:29:55.1533333+00:00

Hi @Kashish

Do you have further question on this issue, could we offer more support?

If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

1 answer

Your answer

LiHongMSFT-4306 31,576 Reputation points

2023-11-30T02:29:55.1533333+00:00

Hi @Kashish

Do you have further question on this issue, could we offer more support?

If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

Hi @Kashish

You could use the Data Migration Assistant (DMA).

DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.

Please refer to this tech doc for more details: Overview of Data Migration Assistant.

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".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Best tool and technique to perform the Sql server to sql server migration.

1 answer

Your answer