International Journal of Innovative Technology and Exploring Engineering (IJITEE)
An automobile industry is transitioning to a new electronic enterprise Product Lifecycle Management (PLM) environment using the WindchillPDMLink 10.0 application from Windchill 5.0. The development teams were using software called EIS, which does not have proper workflow. Even though new software exists the users were using the legacy EIS database. Data migration between EIS and WindchillPDMLink 10.0 has to be performed parallel. This involved a mechanism of downloading the data from EIS database and upload into Windchill database. In order to extract the data from EIS database, SQL scripting language is used.