edu.northwestern.at.utils.tools
Class CompareDB

java.lang.Object
  edu.northwestern.at.utils.tools.CompareDB

public class CompareDB
extends java.lang.Object

MySQL database structure comparison tool.

Usage:

CompareDB url1 username1 password1 url2 username2 password2

url1, username1, password1 = URL, username, and password for first database.

url2, username2, password2 = URL, username, and password for second database.

This tool compares the structures of the two databases and prints a report on stdout. The following differences, if any, are reported:

• Tables that are in one but not the other database.
• Columns that are in a table in one database but are not in the the same table in the other database.
• Differences in the attributes of columns: type, whether or not null values are permitted, indexing attributes, default value, and MySQL "extra" information.

Method Summary

static void

main(java.lang.String[] args) The main program.

Methods inherited from class java.lang.Object

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

Method Detail

main

public static void main(java.lang.String[] args)

The main program.

Parameters:

args - Command-line arguments.