• Report

Criteria for evaluating general database migration tools

Citation

Wei, B., & Chen, T. (2012). Criteria for evaluating general database migration tools. (RTI Press Publication No. OP-0009-1210). Research Triangle Park, NC: RTI Press. DOI: 10.3768/rtipress.2012.op.0009.1210

Abstract

Software updates often involve data migration, especially when converting legacy software implemented to interface with outdated relational database management systems or other nonrelational database electronic files. Moreover, many software applications rely on data migration to import data from a variety of platforms. Usually, database migrations are time consuming and error prone. Based on their experience designing and implementing custom utilities to convert a large number of legacy databases and files in different platforms, RTI computer scientists developed five criteria that need to be considered when evaluating a data migration tool (DMT). These criteria can help users and software development project managers make informed decisions in data conversion tasks, help software developers assess design and implementation considerations for future DMT products, and provide guidelines for database administrators to evaluate a general DMT.

Author Details

B Wei

Bin Wei, MS, is a senior researcher at the Pacific Islands Fisheries Science Center, a National Oceanic and Atmospheric Administration (NOAA) research branch within the Joint Institute for Marine and Atmospheric Research, a NOAA Cooperative Institute at the University of Hawaii at Manoa.* His areas of expertise include designing systems for remote data collection and data transformation.

Tennyson Chen

Tennyson X. Chen, MS, is a senior research analyst and software system architect in RTI International’s Research Computing Division. His main focus is the National Survey of Drug Use and Health (NSDUH) project, for which he is a key system designer and database manager.