Originally Posted by Horace

A "normal" IT approach would be a system in which hotels continue to submit transactions with whatever account number is associated with a guest's stay — old SPG number, new SPG number, or Rewards number —and for the system upstream to use cross-reference tables to post that transaction correctly.

This doesn't seem like rocket science. It should not be a "total mess."