Apache DdlUtils

DdlUtils

import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;
import org.apache.ddlutils.Platform;
import org.apache.ddlutils.PlatformFactory;
import org.apache.ddlutils.io.DatabaseIO;
import org.apache.ddlutils.model.Database;

public class Main {

 public static void main(String[] args) throws Exception {
  Properties properties = new Properties();
  properties.setProperty("driverClassName", "oracle.jdbc.driver.OracleDriver");
  properties.setProperty("url", "jdbc:oracle:thin:@localhost:1521:orcl");
  properties.setProperty("username", "username");
  properties.setProperty("password", "password");
  
  DataSource dataSource = BasicDataSourceFactory.createDataSource(properties);
  Platform platform = PlatformFactory.createNewPlatformInstance(dataSource);
  String resultingName = "database";
  String catalog =null;
  String schema = "SCHEMA_NAME";
  String[] tableTypes = new String[]{"TABLE"};
  Database model = platform.readModelFromDatabase(resultingName, catalog, schema, tableTypes);
  String fileName = "database_ddl.xml";
  new DatabaseIO().write(model, fileName);
 }
}