Criteria for evaluating general database migration tools

By Bin Wei, Tennyson Chen

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.


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.

© 2019 RTI International. This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.


Bin WeiBin 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 ChenTennyson 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.

Contact RTI Press

To contact an author, request an exam or review copy, or seek permission to use copyrighted content, contact our editorial team.