Re: Microsoft Access migration: Referential Integrity

[Scott Harmon]

Thanks for your quick response! :)

I editted MigrationGeneric.java, method migrationForeignKeyToMysql, changing:

if ((overrideRules != null)
&& (overrideRules.compareToIgnoreCase("yes") == 0)) {
targetForeignKey.setDeleteRule(migrationParams
.get("defaultDeleteRule"));
targetForeignKey.setUpdateRule(migrationParams
.get("defaultUpdateRule"));
}

to

if ((overrideRules != null)
&& (overrideRules.compareToIgnoreCase("yes") == 0)) {
targetForeignKey.setDeleteRule(migrationParams
.get("defaultDeleteRule"));
targetForeignKey.setUpdateRule(migrationParams
.get("defaultUpdateRule"));
} else {
targetForeignKey.setDeleteRule(sourceForeignKey.getDeleteRule());
targetForeignKey.setUpdateRule(sourceForeignKey.getUpdateRule());
}

and now it works! :^)

Thanks again,

Scott.