sql server forums

Shri 21 Reputation points

Hi Expert,

I am doing migration of sql server 2012 from server A to server B. There is no connectivity between server A to server B. so will be doing backup and restore . we have availability group name called group1,group2group3. so while migrating, can we use the same availability group 'name' as it is to server B or it suppose to be different



SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
459 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,936 Reputation points Microsoft Vendor

    Hi Shri-5469,
    I think it works.
    And for listener, you can create a listener called listenername_NEW in Server B, and once everything is really for the cut-over, you can rename the listener name of alwayson from server A to listenername _old and then rename listenername_NEW to listenername.
    Here is a similar thread which might help.

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.