any good WORKING scheme editor/updater? 1

[jpo245]

Hi everyone,

So i designed my first database (~15 tables, many many many relationships). Was working fine, but decided to fine tune it a bit, normalize it a bit more, rename all the table/field names to more meaningful ones etc.

Is there any GOOD software that is able to extract the current schema and allow me to modify and update it?

I tried using MYDBPAL which seemed quite promising, but it gives me too many access violation errors.I can't even use the schema editor.

FABFORCE is reasonable, but i find MICROOLAP is much better.
However, my trial for Microolap ran out, and i can't afford 125 bucks for it.

So its not just an edtior im looking for, but something that allows me to maintain the database and update the schema as and when my needs change.

1. What do you guys use?
2. Is there any quick way to recode all my php to suit the new schema? I'm currently thinking im gonna have to recode all the sql, fieldnames, etc in my php code.argghh...


Thanks!

 

[doug04]

http://www.altova.com/products_mapforce.html

 

[jpo245]

doug, that is AWESOME!!!!
thanks for the valuable suggestion.

It looks really complex though, and would probably be an overkill for my website... i'd probably be finished coding by the time i learn how to properly use mapforce!

im thinking of getting stylevision though. that will speed things up for me immensely...

oh i managed to find another reasonable solution,
EMS Mysql manager. Very very good too.