Migrating from old AlwaysOn Availability Group to new AG cluster but keep ip addresses



  • We want to migrate our SQL Server 2012 on server 2012R2 to SQL Server 2019 on server 2016 and keep the ip addresses but change hostnames.

    i can not change the name of listener and ip addresses from application code. We have 10 TB data. We have been using single availability group.

    Current situation :

    LISTENER : SQLLSN : 10.10.12.12
    

    SQL_OLD1 - 10.10.12.2
    SQL_OLD2 - 10.10.12.3
    SQL_OLD3 - 10.10.12.4

    Windows Server 2016 - SQL Server 2019

    SQL_NEW1 - 10.10.12.5
    SQL_NEW2 - 10.10.12.6
    SQL_NEW3 - 10.10.12.7

    After migration:

    LISTENER : SQLLSN : 10.10.12.12
    

    SQL_NEW1 - 10.10.12.2
    SQL_NEW2 - 10.10.12.3
    SQL_NEW3 - 10.10.12.4

    Any information and suggestion would be very appreciated.



  • Since it's all in the same subnet, when you cut over just https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/remove-an-availability-group-listener-sql-server?view=sql-server-ver15 from the old cluster and https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server?view=sql-server-ver15 with the same name and IP to the new cluster.

    There's no need to change the IP addresses of the new nodes to match the IP addresses of the old servers. The App should be connecting to the AG Listener IP only.

    So you end up with:

    LISTENER : SQLLSN : 10.10.12.12
    

    SQL_NEW1 - 10.10.12.5
    SQL_NEW2 - 10.10.12.6
    SQL_NEW3 - 10.10.12.7




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2