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

Rahul 251 Reputation points
2023-11-23T14:28:59.9866667+00:00

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.

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,324 questions
{count} votes

1 answer

Sort by: Most helpful
  1. LiHongMSFT-4306 25,651 Reputation points
    2023-11-24T02:47:46.9933333+00:00

    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.

    0 comments No comments