public static void main(String[] args) throws Exception {
// database connection
@SuppressWarnings("unused")
Class driverClass = Class.forName("com.mysql.jdbc.Driver");
Connection jdbcConnection = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/scrumit2", "root", "bsgroup");
IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);
// partial database export
//QueryDataSet partialDataSet = new QueryDataSet(connection);
//partialDataSet.addTable("FOO", "SELECT * FROM TABLE WHERE COL='VALUE'");
//partialDataSet.addTable("BAR");
//FlatXmlDataSet.write(partialDataSet, new FileOutputStream("partial.xml"));
// full database export
IDataSet fullDataSet = connection.createDataSet();
FlatXmlDataSet.write(fullDataSet, new FileOutputStream("full.xml"));
// dependent tables database export: export table X and all tables that
// have a PK which is a FK on X, in the right order for insertion
//String[] depTableNames = TablesDependencyHelper.getAllDependentTables(connection, "X");