Compare two database

[forgot]

Hello

Thank you this will be very useful for all for nuBuilder guys.

What do you manage changes in dev - prod environment or dev - test - prod environment ?
What tool or tools do you use?

I mean synchronization for DB schema and table’s data. Compere two DB, see any changes and apply only these changes to productive instance without redeployed whole MySQL DB.

Maxim

[pickle_jimmy]

Hi Maxim,

We use svn for version control of the nuBuilder code (the stuff in the build directory), but currently do not version control our database schemas.

The schemas are versioned in a haphazard - run this SQL from the change log - method.

I am (on my list of things to finish) working on a schema dump/compare/update tool for nuBuilder but this isnt as yet part of
the system.

Regards

Pickle Jimmy

[forgot]

I mean tools for developer in neBuilder not developer of nuBuilder.
So it only issue with compere db because I newer touch php files.

For Windows I find tool dbForge Studion for MySQL with two options:
1. Compare Shames
2. Compare Data.

And now I easily can synchronize developer and productive instance of nuBuilder with couple of click.


Maxim

[admin]

Maxim,

I'll have a look at dbForge.

Steven