Migrating a Well-Established Longitudinal Cohort Database From Oracle SQL to Research Electronic Data Entry (REDCap): Data Management Research and Design Study

Katharina Kusejko   ^{1, 2} , PhD ;   Daniel Smith   ¹ , MSc ;   Alexandra Scherrer   ² , PhD ;   Paolo Paioni   ³ , MD ;   Malte Kohns Vasconcelos   ⁴ , MD ;   Karoline Aebi-Popp   ^{5, 6} , MD ;   Roger D Kouyos   ^{1, 2} , PhD ;   Huldrych F Günthard   ^{1, 2} , MD ;   Christian R Kahlert   ^{7, 8} , MD ;   Swiss HIV Cohort Study and the Swiss Mother and Child HIV Cohort Study   ⁹

¹ Institute of Medical Virology, University of Zurich, Zurich, Switzerland

² Division of Infectious Diseases and Hospital Epidemiology, University Hospital Zurich, Zurich, Switzerland

³ Division of Infectious Diseases and Hospital Epidemiology, University Children's Hospital Zurich, Zurich, Switzerland

⁴ Department for Infectious Diseases and Vaccinology, University of Basel Children’s Hospital, Basel, Switzerland

⁵ Department of Infectious Diseases, Inselspital Bern, University of Bern, Bern, Switzerland

⁶ Department of Obstetrics and Gynecology, Lindenhofspital, Bern, Switzerland

⁷ Department of Infectious Diseases and Hospital Epidemiology, Cantonal Hospital St Gallen, St Gallen, Switzerland

⁸ Division of Infectious Diseases and Hospital Epidemiology, Children’s Hospital of Eastern Switzerland, St Gallen, Switzerland

⁹ See Acknowledgements, Zurich, Switzerland