From oracle-l-bounce@freelists.org Fri Oct 8 14:08:46 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i98J8j911112 for ; Fri, 8 Oct 2004 14:08:45 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i98J8bI11084 for ; Fri, 8 Oct 2004 14:08:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4D80872DA77; Fri, 8 Oct 2004 14:14:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15397-82; Fri, 8 Oct 2004 14:14:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A58EE72C5A9; Fri, 8 Oct 2004 14:14:27 -0500 (EST) Message-ID: Date: Fri, 8 Oct 2004 20:12:20 +0100 From: Jared Still To: raymond.feighery@churchill.com Subject: Re: OT: Unix Version Control Cc: "oracle-l@freelists.org" In-Reply-To: <817D2444710B934B9F7B8A1DAAF432D6066EB836@brcexm03> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <817D2444710B934B9F7B8A1DAAF432D6066EB836@brcexm03> X-archive-position: 10844 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On Fri, 8 Oct 2004 15:03:54 +0100, Feighery, Raymond (RBS Insurance) wrote: > I've got a bunch of SQL, ksh and perl scripts that I want to organise, > archive and delete where obsolete. I'd like to get these into some sort of > version control repository (rather than the .old .bkp .date etc "system" > currently employed) and I was wondering what systems (if any) you use. SCCS? > RCS? CVS? > > Recommendations/experiences/gotchas gratefully received. > > Ray > Hi Ray, Here's a synopsiis of my experience with these tools. I've used all three, and currently use RCS for version control on all Perl and Oracle scripts. SCCS: I started out using sccs, but switched to RCS when I was able, as RCS is much more capable. RCS: Excellent tool for version control on scripts. You don't often need to go back to an old version, but it's nice to have when you do. There are many other features, such as branching, but I think those are best exploited via CVS. RCS files can be transported between *nix systems without any kind of conversion, including cygwin. They may also be used directly with the Windows version of RCS, with the proviso that the ',v' needs to be dropped from the suffix of the RCS file names. CVS: This is an application level versioning system. You don't just version files, but entire releases. I've used it in the past for a project, but it's been awhile. There are also nice gui interfaces for it. I would think that if used for scripts, it might be put to good use to control releases of scripts for different versions of Oracle, platforms, etc. CVS is a bit of work to setup, but could be worthwhile if you think you need it. HTH -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l