Please remove me from this email group.
-----Original Message-----
From: Ryan Schmidt [mailto:subversion-2007a@ryandesign.com]
Sent: Monday, February 05, 2007 7:59 PM
To: Dilip Sundaramurthy
Cc: users@subversion.tigris.org
Subject: Re: Pls register me to the user group.
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Tue Feb 6 13:01:48 2007