Customized Data Migration between Two Different Database Vendors

A system upgrade, implementation or consolidation is almost always followed by data migration from legacy systems to newer technologies. 7eleven worked on a legacy data migration project, wherein the old site was built using ColdFusion and the client was interested to migrate to a new site which would be developed in PHP. At the same time, while the old site had MSSQL server as the database vendor, the client wanted the new site to have MySQL as the preferred database vendor.

To know how 7eleventech ingeniously overcame the hurdles to make the migration process both schema and database vendor independent click moreā€¦

Description page:

For any system upgrade, implementation or consolidation, data migration from legacy systems to newer technologies assumes paramount significance. There could be a gamut of reasons for data migration such as including replacements in server or storage equipment, maintenance or upgrades in the existing schema, application migration from one database to another, website consolidation or relocation of data center. 7eleven got an opportunity to work on a legacy data migration project, wherein the old site was built using ColdFusion and the client was interested to migrate to a new site which would be developed in PHP.
The project had the following two main requirements:
Migration of legacy data from the old sites database to the new sites database.
Forward the live data coming in to the old site to the new sites database.
At the same time it posed the following two hurdles as well:
The database schema of the sites were different
The old site had MSSQL server as the database vendor while the new site had MySQL as the vendor
7eleventech ingeniously overcame the hurdles to make the migration process both schema
and database vendor independent. A seamless migration translates into an increase in
effectiveness and ease of use of the new system. The client has been able to significantly
bridge its databases and every live data is immediately forwarded to the new site after
storing it in the older one.

About our Client

Client Description: Media Company
Client Location: USA
Industry: Media

Technologies

ColdFusion, MySQL