How to create a database alias in SQL Server 2008 so that I can do the database migration from old SQL 2005 box into another SQL Server 2008 and not have to make some changes in the application server itself ?
SQL Server 2005 SP4 Standard 32 bit
DB name: SQLDB05
SQL Server 2008 R2 SP1 Enterprise 64 bit cluster
DB Name: SQLCluster01
how to make sure the cutover of the database using detach and re-attaching is seamless or transparent to the application server (SharePoint, web application and some other windows application) ?
DNS CName / alias record will be created to point the old box server name into the SQL 2008 box.