public static function usage_extended()
{
$s = dbsteward::usage();
$s .= "DBSteward Conversion and Comparison tools:\nSQL diffing\n --oldsql=<old.sql> ...\n --newsql=<old.sql> ...\n --outputfile=<outputfile.ext>\nSlony utils\n --slonikconvert=<slonyconfig.slonik>\n --slonycompare=<database.xml> ... generate table SELECT statements for database health comparison between replicas\n --slonydiffold=<olddatabase.xml> ... compare table slonyId assignment between two versions of a database definition\n --slonydiffnew=<newdatabase.xml> ...\n --slonyidin=<database.xml> read this file's definition\n --slonyidout=<compositeoutput.xml> output it here with slonyids specified, based on requireslonyid and requireslonysetid\n --slonyidstartvalue=1 start slony IDs at this number\n --slonyidsetvalue=1 use this slony set ID for any unspecified slonySetId attributes\nDatabase definition extraction utilities\n --dbschemadump\n --dbdatadiff=<againstdatabase.xml> ...\n --dbhost=<hostname>\n --dbport=<TCP-port>\n --dbname=<database_name> for mysql5, specify a comma-separated list of databases. e.g. --dbname=one,two,three\n --dbuser=<username>\n --dbpassword=<password>\nFormat-specific options\n --useautoincrementoptions mysql5: Apply AUTO_INCREMENT tableOptions. By default these are ignored.\n --useschemaprefix mysql5: Instead of merging schemas together (mysql5 default behavior),\n prefix each database object with the schema name.\n";
return $s;
}