Accordingly, what is needed is a system and method for allowing data migration between a first data storage system and a second data storage system while the database is open and a real-time data migration that is completely transparent to the host or data processing unit.