mysql settings.php database connection

I maintain a production and development environment. I commonly sync the files and database data and switch the connection string for the environment. For both production and development, the database is only accessible from the hosted machine. Shouldn't this be possible, i.e.,

Development string (If available load and move on. if dev server not available, use the next string)
Production string

Thanks!