Switching users form courseA to courseB

Switching users form courseA to courseB

by Gabe Norton -
Number of replies: 0
I have a course that for reasons beyond my control is no longer being offered but the students will be transfered to the 'next class, that now includes the content from the first class.

I would like to move the students in bulk, but don't want to use the update feature of the upload students option as I don't want to worry about any other classes the students might also be enrolled in.

Can anyone tell me what table the enrollments are kept in? and if changing this entry on a per student basis would have any adverse effects?

I was thinking of something like

UPDATE `table_with_enrollments` SET `course` = `course_id_for_courseB` WHERE `course` = `course_id_courseA`;

Does this sound like it would work?
Average of ratings: -