Re: Database file checkin

[Mark D. Baushke]

Daniel Hurtubise <address@hidden> writes:

> Dear CVS Users,
> 
> Has anybody checked in a database backup into CVS? I know this may sound
> odd, but I was thinking of taking a snapshot of my SQL Server database in a
> empty data state and then checking it into CVS.
> 
> Basically, I just want to track my stored procedures and table schemas
> because I replicate this database for distinct customers. The database is
> tightly coupled to a Web application which I manage under CVS also and I'll
> like to keep both the database and web application components in sync.
> 
> Will there be any issues with checking that backup out of CVS and restoring
> a new database from it? I will test this on my own, but I was wondering if
> anyone else has taken this path before.

Most databases contain binary files and cvs is not optimized well for
dealing with lots of versions of binary files.

If the 'snapshot' you are taking is in plain text, then you will
probably not have a problem using cvs. 

You may wish to tag significant collections of files as being consistent
at a given time to make restoration easier.

        Good luck,
        -- Mark