<?php
require 'tutorial_autoload.php';

// create the two ezcDbSchema objects:
$xmlSchema = ezcDbSchema::createFromFile( 'xml', 'wanted-schema.xml' );
$db = ezcDbFactory::create( 'mysql://user:password@host/database' );
$dbSchema = ezcDbSchema::createFromDb( $db );

// compare the schemas:
$diffSchema = ezcDbSchemaComparator::compareSchemas( $dbSchema, $xmlSchema );

// return an array containing the differences as SQL DDL to upgrade $dbSchema
// to $xmlSchema:
$sqlArray = $diffSchema->convertToDDL( $db );

// write the differences to a file:
$diffSchema->writeToFile( 'array', 'differences.php' );

// apply the differences to the database:
$diffSchema->applyToDB( $db );

?>