As long as the database structure is the same (i.e. the database name, table names, column names, and column types), then you can change the server address with no problems.
Actual Technologies - ODBC for Mac OS X
It will have the same database structure, thanks for the response. I will update the thread after I make the address switch!
I was able to switch the ODBC connection over today without any issues!