Page 1 of 1

Compare two database

Posted: Thu Sep 13, 2012 4:11 pm
by 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

Re: Compare two database

Posted: Fri Sep 14, 2012 8:14 am
by 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

Re: Compare two database

Posted: Tue Sep 18, 2012 10:14 am
by 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

Re: Compare two database

Posted: Wed Sep 19, 2012 2:02 am
by admin
Maxim,

I'll have a look at dbForge.

Steven