NAME

sql2sql_single - convert a course from the sql to the sql_single database layout.

SYNOPSIS

 sql2sql_single COURSEID NEWDBNAME DBADMIN DBPASS

DESCRIPTION

Convert a course database using the sql database layout to use the <sql_single> database layout instead. This is done by moving the tables of the course database into the single database used by the sql_single database layout. For this to work, both layouts must be using the same database server.

NEWDBNAME gives the name of the database used by sql_single. This is usually ``webwork''. DBADMIN and DBPASS are respectively the username and password of an administrative account on the SQL server.

After running this script, you must edit the course's course.conf file, chainging the database layout from sql to sql_single.

AUTHOR

Written by Sam Hathaway, hathaway at users.sourceforge.net.