{"thread":{"id":"28336","subject":"Re: Tracking database changes.","startedAt":"2011-09-08T12:12:25Z","lastAt":"2011-09-08T12:16:09Z","messageCount":2,"participants":["Rodrigo Cortés","Victor Engmark"],"isPatch":false,"patchVersion":null,"patchTotal":null},"messages":[{"id":"175090","messageId":"20110908121225.GC32087@victor.terreactive.ch","threadId":"28336","inReplyTo":"30328581.178675.1315346163453.JavaMail.trustmail@mail1.terreactive.ch","subject":"Re: Tracking database changes.","fromName":"Victor Engmark","fromEmail":"victor.engmark@terreactive.ch","sentAt":"2011-09-08T12:12:25Z","receivedAt":"2011-09-08T12:12:25Z","isPatch":false,"sender":{"key":"victor.engmark@terreactive.ch","avatar":null},"body":"On Tue, Sep 06, 2011 at 06:55:56PM -0300, Rodrigo Cortés wrote:\n> Is there a way to use git to track database changes?\n\n1. Export the data and/or data model with a tool like mysqldump.\n2. Remove output which would clutter up your diffs without adding any\nuseful information. This could include things like date and time of the\nexport and user name of the exporter.\n3. Commit and enjoy!\n\nOptionally create a cron job to export and commit automatically during\noff-peak hours.\n\nCheers,\nVictor\n\n-- \nterreActive AG\nKasinostrasse 30\nCH-5001 Aarau\nTel: +41 62 834 00 55\nFax: +41 62 823 93 56\nwww.terreactive.ch\n\nWir sichern Ihren Erfolg - seit 15 Jahren\n"},{"id":"175089","messageId":"CAFSYZ5T1fhej26KfT1TtGQ6+U4=v1YxV1uTTD=poYNeQW15w5g@mail.gmail.com","threadId":"28336","inReplyTo":"20110908121225.GC32087@victor.terreactive.ch","subject":"Re: Tracking database changes.","fromName":"Rodrigo Cortés","fromEmail":"rcortes.ing@gmail.com","sentAt":"2011-09-08T12:16:09Z","receivedAt":"2011-09-08T12:16:09Z","isPatch":false,"sender":{"key":"rcortes.ing@gmail.com","avatar":null},"body":"So... there is no \"plugin\" for git to do that work.\n\nOn Thu, Sep 8, 2011 at 9:12 AM, Victor Engmark\n<victor.engmark@terreactive.ch> wrote:\n> On Tue, Sep 06, 2011 at 06:55:56PM -0300, Rodrigo Cortés wrote:\n>> Is there a way to use git to track database changes?\n>\n> 1. Export the data and/or data model with a tool like mysqldump.\n> 2. Remove output which would clutter up your diffs without adding any\n> useful information. This could include things like date and time of the\n> export and user name of the exporter.\n> 3. Commit and enjoy!\n>\n> Optionally create a cron job to export and commit automatically during\n> off-peak hours.\n>\n> Cheers,\n> Victor\n>\n> --\n> terreActive AG\n> Kasinostrasse 30\n> CH-5001 Aarau\n> Tel: +41 62 834 00 55\n> Fax: +41 62 823 93 56\n> www.terreactive.ch\n>\n> Wir sichern Ihren Erfolg - seit 15 Jahren\n>\n\n\n\n-- \nRodrigo Cortés Carvajal\nIngeniería Eléctrica\nUniversidad Tecnológica de Chile\n"}]}