Re: Tracking database changes.

Victor Engmark· Sep 8, 2011, 12:12 UTC · lore

On Tue, Sep 06, 2011 at 06:55:56PM -0300, Rodrigo Cortés wrote:

> Is there a way to use git to track database changes?

1. Export the data and/or data model with a tool like mysqldump.
2. Remove output which would clutter up your diffs without adding any
useful information. This could include things like date and time of the
export and user name of the exporter.
3. Commit and enjoy!

Optionally create a cron job to export and commit automatically during off-peak hours.

Cheers, Victor

-- 
terreActive AG
Kasinostrasse 30
CH-5001 Aarau
Tel: +41 62 834 00 55
Fax: +41 62 823 93 56
www.terreactive.ch

Wir sichern Ihren Erfolg - seit 15 Jahren

Rodrigo Cortés· Sep 8, 2011, 12:16 UTC · re: Victor Engmark · lore

So... there is no "plugin" for git to do that work.

On Thu, Sep 8, 2011 at 9:12 AM, Victor Engmark <victor.engmark@terreactive.ch> wrote:

Show 25 quoted lines

> On Tue, Sep 06, 2011 at 06:55:56PM -0300, Rodrigo Cortés wrote:
>> Is there a way to use git to track database changes?
>
> 1. Export the data and/or data model with a tool like mysqldump.
> 2. Remove output which would clutter up your diffs without adding any
> useful information. This could include things like date and time of the
> export and user name of the exporter.
> 3. Commit and enjoy!
>
> Optionally create a cron job to export and commit automatically during
> off-peak hours.
>
> Cheers,
> Victor
>
> --
> terreActive AG
> Kasinostrasse 30
> CH-5001 Aarau
> Tel: +41 62 834 00 55
> Fax: +41 62 823 93 56
> www.terreactive.ch
>
> Wir sichern Ihren Erfolg - seit 15 Jahren
>

-- 
Rodrigo Cortés Carvajal
Ingeniería Eléctrica
Universidad Tecnológica de Chile