in reply to Automated detection of different tables with same name

You can do it in Perl... Or you could look at other tools.

What I would think of, is find a way to do a structure dump of the databases to text files, the way MySQL can do it, and then compare them with a standard diff. That'll focus on the differences.

I've hunted around a little, and it seems to me this guy has written a tool to dump the database structure for MS-SQL databases.

  • Comment on Re: Automated detection of different tables with same name