Hello there,

I was wondering if anyone was aware of any application that can track mySQL
database schema changes.

Here is what im trying to achieve;
We have a database that is poorly designed, I shall call this the 'Start'
database
I want to make a whole bunch of changes to the schema that once done I shall
call the 'End' database
I then want to develop the application according to the 'End' databases
schema
Once the applocation is ready I then want to execute a script that makes the
changes to the 'Starting' database

Thank you kindly for your time any thoughts
John Sheppard

== Quote from John Sheppard (spam@nospam.com)'s article
> Hello there,
> I was wondering if anyone was aware of any application that can track mySQL
> database schema changes.
> Here is what im trying to achieve;
> We have a database that is poorly designed, I shall call this the 'Start'
> database
> I want to make a whole bunch of changes to the schema that once done I shall
> call the 'End' database
> I then want to develop the application according to the 'End' databases
> schema
> Once the applocation is ready I then want to execute a script that makes the
> changes to the 'Starting' database
> Thank you kindly for your time any thoughts
> John Sheppard

to do this effectively, i'd recommend storing the dump from various stages of the
database in a cvs server. you can very accurately tack any and all changes to the
dump file which will lead you to the database changes.

--
POST BY: lark with PHP News Reader ;o)

"lark" <hamzee@sbcglobal.net> wrote in message
news:aMU5j.29084$lD6.9106@newssvr27.news.prodigy.n et...
> == Quote from John Sheppard (spam@nospam.com)'s article
>> Hello there,
>> I was wondering if anyone was aware of any application that can track
>> mySQL
>> database schema changes.
>> Here is what im trying to achieve;
>> We have a database that is poorly designed, I shall call this the 'Start'
>> database
>> I want to make a whole bunch of changes to the schema that once done I
>> shall
>> call the 'End' database
>> I then want to develop the application according to the 'End' databases
>> schema
>> Once the applocation is ready I then want to execute a script that makes
>> the
>> changes to the 'Starting' database
>> Thank you kindly for your time any thoughts
>> John Sheppard
>
> to do this effectively, i'd recommend storing the dump from various stages
> of the
> database in a cvs server. you can very accurately tack any and all changes
> to the
> dump file which will lead you to the database changes.
>
> --
thanks man, yeah I couldnt really find anything that did it live, so i've
found navicat, and thats a good peice of software, I will use its compare
feature to get the changes.

"John Sheppard" <nospam@spamspam.com> wrote in message
news:fk6s8q0qrt@news2.newsguy.com...
>
> "lark" <hamzee@sbcglobal.net> wrote in message
> news:aMU5j.29084$lD6.9106@newssvr27.news.prodigy.n et...
>> == Quote from John Sheppard (spam@nospam.com)'s article
>>> Hello there,
>>> I was wondering if anyone was aware of any application that can track
>>> mySQL
>>> database schema changes.
>>> Here is what im trying to achieve;
>>> We have a database that is poorly designed, I shall call this the
>>> 'Start'
>>> database
>>> I want to make a whole bunch of changes to the schema that once done I
>>> shall
>>> call the 'End' database
>>> I then want to develop the application according to the 'End' databases
>>> schema
>>> Once the applocation is ready I then want to execute a script that makes
>>> the
>>> changes to the 'Starting' database
>>> Thank you kindly for your time any thoughts
>>> John Sheppard
>>
>> to do this effectively, i'd recommend storing the dump from various
>> stages of the
>> database in a cvs server. you can very accurately tack any and all
>> changes to the
>> dump file which will lead you to the database changes.
>>
>> --
> thanks man, yeah I couldnt really find anything that did it live, so i've
> found navicat, and thats a good peice of software, I will use its compare
> feature to get the changes.

dang it I cant do that, it drops and recreates the table so im gonna lose
data

back to the drawing board