db synchronization

Hi,

I am using MySQL.
do you know a php script or a software which do this:
- compare 2 db schemas and update the production schema from the DEV schema.

Only the schema, not the DATAS!!
For example:
- you add a table within your DEV environment -> it creates the table
(without the data) on the production server
- you add a field within a table within your DEV environment -> it creates
adds the field within the same table (and of course set the defaut value of
all the existing fields for this column) on the production server
- optionnaly, only if you set a flag, it should remove fields on the
production environment if it has been removed on the dev environment (but
not always, only if you set a flag!!)

All the existing softwares do a "easy" synchronization (mydb etc )!!
They only create new tables (the full tables) and export datas!!!

Is there a way to detect news fields and update the schema???

Many thanks

Rod



.

Relevant Pages

  • Re: Move sharepoint to another server
    ... test environment's schema that aren't in your production's schema. ... customization in your production environment. ... > sharepoint portal server 2003 in my test server, now i want to move all ... Please upgrade the database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: refreshing AD in testlab environment
    ... If you have two separate forests you can't magically bring across schema ... want to bring the testlab up to production leve. ... service accounts we use in production are different than the testlab. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Test Environment - How?
    ... I need the schema to come across (actually, if I could get the schema ... production, but I only want 2-3 in test, so I assume I don't want ... In addition to what Simon already suggested, you could try and test your Domain Controller backups by restoring the Active Directory Backups on the test environment machines. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Question on Active Directory Schema Expansion
    ... All of my experience in the last 10 years has been in Fortune 50 or bigger, primarily Fortune 5 all of which tend to have banking or trading divisions. ... Prior to doing an actual live production forest update of a schema I tend to recommend sucking off the live production domains onto DCs and stick them in a segregated room cut off from the rest of the network and apply the changes there and see how they impact the production schema. ... I recall the first schema update we did for one of the Fortune 5 companies that MS told us would be done in about 90 minutes because that is what it took in the lab they mocked up for it... ...
    (microsoft.public.win2000.active_directory)
  • Re: what is the duration of forestprep in an existing exchange organization?
    ... test system, I think I can do it without loosing a weekend;-)) ... > Forestprep is updating the schema on the schema master. ... > environment has similar hardware to production then assume the same amount ... Exchange not be affected when Forestprep is being ...
    (microsoft.public.exchange.setup)