A method, apparatus, and computer program product are disclosed for managing and migrating data. A request is received from an application for data. The request is in a database-specific format. A determination is made regarding whether the data is located in a first database that utilizes the database-specific format. In response to determining that at least part of the data has been migrated from the first database, each current location of each part of the data is identified. A first request is generated for a first location of a first part of the data. The first request is in a database-specific format of the first location. A second request is generated for a second location of a second part of said data. The second request is in a database-specific format of the second location. The first and second parts of the data are combined into a complete result set that includes all of the originally requested data. A response to the request is generated for the application that includes the complete result set in the database-specific format.