Sql-server – MS SQL Server IP address change considerations

migrationsql server

I am very new to MS SQL Server Administration and wants to learn on Migration of SQL Server in detail. We are in a Datacenter migration Project where the Windows server (SQL Server is residing in it) is going to be migrated AS-IS from Source to Destination. I would like to know what are the things that we need to take care for the SQL Server IP address connectivity issues and other related connectivity problems. correct me if anything wrong in framing the question and thanks in advance

Best Answer

If you are just changing IP address ONLY, then there are less things to worry.

Check

Change the IP address and restart SQL Server.
If your applications are referencing IP address instead of HOST, then they need to change their web.config files to reflect the new IP address.
Linked servers referencing IP address needs to be changed as well.
If any user workstations are connecting using IP, then they need to flush DNS using ipconfig /flushdns or better just restart their workstations.
If the server is part of Failover cluster then follow this steps as well.

If you want to be proactive and find out the applications connecting to your sql server instance, then use this server side trace and then plan accordingly for downtime.

Note: make sure you assign a static IP address and port to sql server.

Related Solutions

Sql-server – SQL Server Table Move Stalled

Shot in the dark: It means you client has reached the configured data/log file size and is now auto-growing them as a snail pace. Make sure you properly pregrow the data and the log files before your data transfer.

Sql-server – Effective way to migrate from SQL Server to MySQL

If you're looking for an easy-to-use, open-sourced tool, checkout etlalchemy.

You can carry out your SQL Server to MySQL database migration with 4 lines of Python code:

To Install:

pip install etlalchemy

(On El Capitan you may have to run pip install --ignore-installed etlalchemy)

To Run:

from etlalchemy import ETLAlchemySource, ETLAlchemyTarget

mssql_db_source = ETLAlchemySource("mssql+pyodbc://username:password@DSN_NAME")

mysql_db_target = ETLAlchemyTarget("mysql://username:password@hostname/db_name", 
              drop_database=True)

mysql_db_target.addSource(mssql_db_source)
mysql_db_target.migrate()

If you want to learn more about etlalchemy, check out this article.

Best Answer

Related Solutions

Sql-server – SQL Server Table Move Stalled

Sql-server – Effective way to migrate from SQL Server to MySQL

Related Question