Re: Database Development w/ SVN

On 11/10/2009 3:44 PM, Daniel Becroft wrote:
> Hi all,
>
> This is more of a best or general practice question than anything
> else. How do you manage/version external database schema and static
> data changes in an SVN environment?

Small static tables could be dumped to a .sql type plain text file
(which is usually just a big SQL INSERT statement) and kept in SVN.
Figure one file per table.

You could probably put the create table queries in .sql files as well.

(Part of our PGSQL backup is to dump the data tables out to .sql files
and store them in SVN using the FSVS tool. So we can easily roll back
to any particular day using those backups.)

------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=1065&dsMessageId=2416862

To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_subversion.tigris.org].
Received on 2009-11-12 07:37:38 CET