MySQL database structure comparation

[zippo]

Hello!

Does anyone know how to compare two database (on the same server) structures? If there's any Delphi code it would be great..

[mdaems]

What do you mean?
Only mysql or db independent?
If mysql: 5 or all versions?
I suppose you want to know what tables/fields are in database A and not in database B and the other way around.


For mysql 5 I would try to write some queries on the information_schema tables. I think some queries must be sufficient.

Using Zeoslib : I would try to use 2*2 metadata components on 2 different connections. For each table in every connection the second component can be used to compare details.

I did not actually try those solutions, however.

Mark

[zippo]

I will show you what I mean:

I have two databases of the same application, but different versions. This means that some tables are missing, some fields are missing, some fields are different (type, size) or some indexes are missing/different.

I would like to see the differences between the two databases.

It can be for MySQL 5 (as the other versions are going to disappear in time).

The idea is that I will need to write it, but if it is written, then why to do the same task twice..

[Jay]

You will have to do 2 conections, 1 for each database. On the base database (the one that is complete) you first do a query (SHOW TABLES) and compare it to a similar query (SHOW TABLES) of the other DB. The diference are the tables that are missing. You then use this list of tables anq do a loop. For each table you can use diferent queries (SHOW FIELDS), (SHOW INDEX) etc. and compare the results to find the missing fields, indexes or any diference in them.

Once you have this routine, it will also apply to any future changes.

Regards,

Jay

[zippo]

Ok, thanks!

I'll make the routines - BTW: If anyone needs them, just drop me a PM or mail..

[waheed]

I don't know how far you got in the routines. But just to let you know:

http://www.sqlmanager.net/en/products/mysql/dbcomparer