Migrating Commonspot Sites

Abstract

This presentation, given at the Cornell Commonspot SIG meeting on March 22, 2006, addresses issues we discovered in moving sites from a test to production server. Content is stored in a per-site Oracle schema, while user identifiers are defined in a per-server schema. When migrating, it's necessary to update user identifiers in the site database. Peter Hoyt and Paul Houle developed a Perl script that examines the database structure, identifies fields that contain user identifiers, and maps them from the old to new server.