DB Diff Renderer

[Mighty Gorgon]

Hi all,
I often use the "Mod Diff Renderer" created by evil<3 and I find that tool really powerful and useful.

I'm wondering if there is such a tool for DB structures: I need the structure of two DB to be compared and possibly having an output of the SQL to run to make the two DB identical.

Since I am creating a mod which requires many modifications to the DB, I'm wondering if there is an easy way to generate DB schemas without writing all the SQL manually.

Is there a ready to use tool for this? Is there something that I could use as a starting point to avoid to rewrite such a tool from scratch?

Thank you very much.

[igorw]

It would probably be possible to write a script for it and that would be very cool. I would probably just get a DB structure backup of each of the DBs and do a diff. Then write up the queries, it's really easy to do.

A starting point would be looking at how phpBB creates db structure backups.

[igorw]

[Mighty Gorgon]

[igorw]

[Mighty Gorgon]

[igorw]

Here's what we have right now, but it sucks and it will change: http://svn2.assembla.com/svn/evilmods/3 ... ols/trunk/

[blazes816]

Me and Igor's version will use a centralized database, updated to be the latest default schema. Gordon, you're welcome to use it too if you wish.

I'm yet to populate it, so it's still empty but here are the details:
MySQL 4.1.11

Host: external-db.s34738.gridserver.com
User: db34738_db_diff
Password: publicPassword
DBname: db34738_db_diff

I will update when it's populated.

[Obsidian]

[igorw]

That's a bit of a hard thing to do, where are you supposed to split it. I think it's an interesting thought though, you should submit it to the [url=http://www.phpbb.com/bugs/phpbb3/tickets.php]3.0 bug tracker[/url].

[Mighty Gorgon]

[blazes816]

Okay, the database has been populated with the latest, stable, released schema.

[Obsidian]

[blazes816]

In a bout of boredom I've started to put something together. I currently creates a .sql file that adds new tables and drops old ones. I'm going to work on adding/removing columns later.

[Mighty Gorgon]