A method for consolidating a database in a Seibel CRM environment is presented. Bypassing the Business Object Layer (BOL) of the Seibel CRM environment, primary keys in a consolidated table are realigned such that a consolidated child table, created from two distinct databases, is able to point to reference items in a single parent table.