[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: Pls register me to the user group.

From: Ryan Schmidt <subversion-2007a_at_ryandesign.com>
Date: 2007-02-06 01:58:41 CET

On Feb 5, 2007, at 03:21, Dilip Sundaramurthy wrote:

>> On Jan 29, 2007, at 04:27, Dilip Sundaramurthy wrote:
>>
>> > I'm new to SUBVERSION. I've used CM tools like SYNERGY/CM & DESIGN
>> > SYNC.
>> >
>> > I'm in the process of evaluating SUBVERSION.
>> > I was told that, with SUBVERSION one can version control the SQL
>> > database.
>> >
>> > We have Project teams who have stored their data in SQL database.
>> > So, I'm particularly interested to know how this database can be
>> > version controlled.
>>
>> The subject of versioning SQL or a database has come up on the
>> mailing list a couple times before, but in my opinion there isn't a
>> really good way to do that, especially not automatically. You might
>> want to look for those previous discussion threads in the mailing
>> list archives at http://svn.haxx.se/users/
>
> I've registered myself to the mailing list. I also saw the
> discussion threads, in the archive, but it didn't help.
>
> I think, you or somebody can suggest me how to achieve this.
>
> We have a Project group which stores image data types in a SQL
> database. These individual images are parts of a complete image.
> A query is run on the SQL database to generate a complete image.
> The individual images in the SQL database, are updated every week.
> So, the query also changes accordingly.
>
> Now, the question is... Is there a way to version control SQL
> queries, in SUBVERSION ?
> And, is there a way to track the changes done to the SQL database,
> in SUBVERSION(or any other tool) ?

Subversion is a versioned file system. You can store anything in it
that makes sense to you. For example if you have your SQL queries in
text files, you can version those text files. Or if you want to dump
the contents of your SQL database to text files (or if you want to
extract the binary data of the images individually out of your
database and save them as image files), then you can version those
too. You would have to write the scripts to do so.

-- 
To reply to the mailing list, please use your mailer's Reply To All  
function
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Tue Feb 6 01:59:01 2007

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.