When planning connectivity with the Database Tier, it's wise not to hard-code any specific database info into the SP client connection.
I've gotten many recommendations to use SQL Alias on the client to point to the DB role in a generic way that doesn't need change in the event that you have to move the Database.
I've also heard people say that they just point the client to a CNAME in the DNS and just update the CNAME when the database moves.
What are the pros/cons of each?
Thanks in advance for any thoughts!