Currently got a standalone configuration and would like to migrate to primary/standby servers.
Got functions that are connecting and doing some reads and updates to tables in a SQL Database and an MSAccess file via ODBC.
If migrated to a primary/standby configuration what would be the impact to these functions, will both servers be establishing connections and trying and read/update the tables at the same time. Reading is not a problem its the update which is worrisome.