Can RCS be used to version control SQL DB & queries ?

Dilip Sundaramurthy <[email protected]> Fri, 9 Feb 2007 13:31:17 +0530
Newsgroups gmane.comp.gnu.rcs
Message-ID <OFDB0E519E.A4870BF9-ON6525727D.002BD8D9-6525727D.002C045D@philips.com>
Dear techies,

I would be greatly thankful, if somebody could suggest me whether RCS 
would serve my below purpose ?

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.
The SQL queries should be saved & the corresponding retrieved data also 
should be versioned.
So that, if I want to get the same data at a later point of time, I should 
be able to query it from the saved query.

Now, the question is... Is there a way to version control SQL queries, in 
RCS ?

And, is there a way to track the changes done to the SQL database, in 
RCS(or any other tool) ?

Also, I need some good backup tool for SQL DB. It should only backup the 
delta(change) w.r.t its previous backup, instead of a complete DB backup.


Thanks, in advance.

Best Regards,
Dilip
************************************************************************
Senior Configuration Engineer
NXP Semiconductors India
#1, Millenia, Murphy Road, Ulsoor, Bangalore- 560008
Tel:  +91 80 4024 7797 (Direct line)
Email: [email protected]
************************************************************************
"Knowledge is the awareness of the extent of our ignorance"
- Bannaje Govindacharya.