We have an application that runs on IIS 7.5 and windows server 2008 R2. The backend is a sql server 2008R2 on a separate windows server 2008.
I want to retire the old sql server and I have built a new sql server. We would like to reuse the name and IP address of the old server for the new sql server and I am sure I can do that however. I wanted to do some testing and I was curious if I could simply change the host file on the application server as follows
old sql server name = new sql server ip address
I thought that might allow use to test our application with the new sql server and also give me an easy reversible change.
Any thoughts?