I was doing this with dumpfiles for postgresql, and it seemed to work
fairly well. Here's what/how I did it:
- Live linux server - running postgresql 8.0
- Local windows development box - running postgresql 8.0
- Schema dumpfile for the live server's database was versioned in subversion
- Local windows development box had a working copy of this dumpfile checked out
- Local windows development box had a scheduled task to dump it's
schema, overwriting the working copy dumpfile
So, whenever I made changes to the database schema on the local
windows development box, subversion would be able to show me the
changes in the dumpfile. It seemed to work pretty well, but the
dumpfiles did have a-few minor differences due to the fact one was
running on windows and one was on linux.
On 6/9/05, Gabor Szabo <szabgab@gmail.com> wrote:
> When developing an application that uses database an interesting
> question arises on how to track the changes you made to the database.
> Changes can be in schema (including indexes, user rights),
> in meta data (e.g. you might keep the string translations of your
> application in an database),
> some might even require some changes to the application data.
> (e.g. in an application earlier the user table had an e-mail field but
> in the new version you
> enable unlimited number of e-mails so you moved the e-mail column of
> the users table
> to a separate table)
>
> Maybe a slightly better explanation of the problem can be see here:
> http://www.dragonsoftru.com/prod_dsds_1.php
>
> How do people maintain versions of a database ?
> How do you make it easy to upgrade your application (including the database) ?
>
> I guess there might be applications providing some help with this.
> What integration exisits with Subversion ?
>
> Gabor
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
> For additional commands, e-mail: users-help@subversion.tigris.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Thu Jun 9 19:38:47 2005