Package de.akquinet.jbosscc.guttenbase.tools.schema.comparison

Class SchemaComparatorTool

java.lang.Object

de.akquinet.jbosscc.guttenbase.tools.schema.comparison.SchemaComparatorTool

public class SchemaComparatorTool
extends Object

Will check two schemas for compatibility and report found issues.

© 2012-2034 akquinet tech@spree

Author:

M. Dahm Hint is used by TableOrderHint to determine order of tables

Constructor Summary

Constructors

Constructor	Description
SchemaComparatorTool(ConnectorRepository connectorRepository)

Method Summary

Modifier and Type	Method	Description
SchemaCompatibilityIssues	check(String sourceConnectorId, String targetConnectorId)	Check compatibility of both connectors/schemata.
SchemaCompatibilityIssues	checkDuplicateIndexes(TableMetaData table)
SchemaCompatibilityIssues	checkEqualColumns(String sourceConnectorId, String targetConnectorId, TableMetaData tableMetaData1, TableMetaData tableMetaData2)
SchemaCompatibilityIssues	checkEqualForeignKeys(TableMetaData sourceTable, TableMetaData targetTable)
SchemaCompatibilityIssues	checkEqualIndexes(TableMetaData sourceTable, TableMetaData targetTable)
SchemaCompatibilityIssues	checkForeignKeys(TableMetaData table)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SchemaComparatorTool

public SchemaComparatorTool(ConnectorRepository connectorRepository)

Method Detail

check

public SchemaCompatibilityIssues check(String sourceConnectorId,
                                       String targetConnectorId)

Check compatibility of both connectors/schemata.

Parameters:

sourceConnectorId -

targetConnectorId -

Returns:

List of found issues. If empty the schemas are completely compatible

checkEqualForeignKeys

public SchemaCompatibilityIssues checkEqualForeignKeys(TableMetaData sourceTable,
                                                       TableMetaData targetTable)

checkEqualIndexes

public SchemaCompatibilityIssues checkEqualIndexes(TableMetaData sourceTable,
                                                   TableMetaData targetTable)

checkDuplicateIndexes

public SchemaCompatibilityIssues checkDuplicateIndexes(TableMetaData table)

checkForeignKeys

public SchemaCompatibilityIssues checkForeignKeys(TableMetaData table)

checkEqualColumns

public SchemaCompatibilityIssues checkEqualColumns(String sourceConnectorId,
                                                   String targetConnectorId,
                                                   TableMetaData tableMetaData1,
                                                   TableMetaData tableMetaData2)