We have a need to migrate from existing hardware that is running SQL 2005 to new hardware running SQL 2008 R2.
When all is said and done we want the same IP and hostname that was on the "old sql 2005" server to be on the new SQL 2008 R2 server hardware.
This is because we don't want to mess with client connection settings or things that are hardcoded in programming, etc.
We currently have the new 2008 R2 box built with a different name.
Is there a way to move the existing 2005 databases, SSIS jobs, SSAS cubes, SSRS reports, etc. (everything, security, etc.) over to the new hardware and then rename the new hardware to the same IP and hostname as the old.
BOTTOM LINE: we are wanting to move sql 2005 from old hardware to new hardware running SQL 2008 R2 without messing with the clients.