jwcolby
jwcolby at colbyconsulting.com
Wed Jul 14 12:34:42 CDT 2010
Michael, I mostly understand all of that. I use SVN with Visual Studio here in my office. I have a programmer that comes in and works and I do C# coding. We both check out / in pretty much daily. I have had to reconcile differences a couple of times. I don't do anything fancy with it though. AFAICT SVN does not add anything into the file itself - author, date etc. Given that it could corrupt a file structure (word or excel) I doubt that it can do that. I think the header info is kept in the repository somewhere. We shall see. I exported a FE to text files and checked them in, then checked them back out. I then made a simple edit to the code behind form for one form and reexported / checked in that one form. Basically I did exactly that, export over the top of an existing text file. SVN tags files on disk with icons and the icon changed from a green check to a red ! until I checked the change in. Unfortunately I it appears that Tortoise doesn't use the same property to find the repository for the diff application because when i tried to use that widget it says it can't find the repository. Sigh. But the concept seems sound. Really the hardest part seems like it would be getting the file back in to the MDB. That is probably not difficult, it would just have to be deleted and then the text file sucked in and saved. John W. Colby www.ColbyConsulting.com Michael Bahr wrote: > John, SVN works the same way as VSS, ClearCase, PVCS, etc. You add your > files or project the first time, this is the base line revision. This > revision is annotated like 0.001 or something like that. > > Then you do a "Checkout" which should add a marker in SVN to indicate that > those files have been checked-out. By checking out you are allowed to > "Check-In" the files. This does not overwrite or destroy the previous > file, just adds another copy to the revisioning process. This increases > the revision by one like 0.002. Now you can do a differential between > 0.001 and 0.002. BTW, differentials only work on text file, not binary. > If you do a "Get" and you make changes you can not do a check-in, you must > do a "Check-Out" first. So over time you will have many revisions of > files and at some point you will want to "release" the files or project as > Version 1.000. Eveything before version 1.000 would be your developement > work for example. Now you have version control. > > Then you continue with your developement with revisions (check-out, make > changes, check-in) until you do another release, for example Ver 1.100. > Here is where you can do differentials between the various releases. > > Now SVN has (should) features that you would really want like header > information in the files. This is important information like date, time, > author, description, revision number, and possibly version number. SVN > probrably uses some keywords to that you must place in the header the > first time (the baseline) and SVN will automatically update these keywords > everytime you do a check-in. The most important items in the header are > the date and revision. So if you were to make a hard copy or have several > soft copies hanging around of the source code you can easily identify the > revision, otherwise it would be very difficult. Doing things your way of > sucking out the objects each time I think would eliminate the header > information thus rendering the check-out files difficult to track. > > So I hope you understand the process of revision and version. Your can be > be done but I think it is a lot of work dealing with Access objects. > Using SVN for .Net projects should be very easy to use and very > beneficial. > > On another note, I would suggest that you come up with a plan for version > control, or SCM (Software Configuration Management). This is for you and > your customers. > > Mike... > >> Yea, but I want source control. >> >> John W. Colby >> www.ColbyConsulting.com >> >> >> Dan Waters wrote: >>> <I am currently faced with a set of FEs that I need to see the >>> differentials >>> of.> >>> >>> FMS has a utility you can purchase called Access Detective. It's about >>> a >>> couple hundred dollars, and you'd quickly get that back in time saved. >>> >>> HTH, >>> Dan >>> >>> >>> Charlotte Foust wrote: >>>> I guess the success will depend on what you hope to gain. Without a >>>> checkin/out from within Access, any changes to a database will have to >>>> be manually exported and then imported to subversion, right? I'm not >>>> familiar with the product, so how do you keep versions of the objects >>>> rather than overwriting, or does it matter? >>>> >>>> Charlotte >>>> >>>> On Tue, Jul 13, 2010 at 4:21 PM, jwcolby <jwcolby at colbyconsulting.com> >>> wrote: >>>>> I am trying a workaround. Max has written code that exports all the >>> objects in an access database >>>>> to text files. It seems a short step to using that to get them into >>> subversion. >>>>> John W. Colby >>>>> www.ColbyConsulting.com >>>>> >>>>> >>>>> Charlotte Foust wrote: >>>>>> How would you move items in an out of Access? Source Safe uses an >>>>>> Access add-in to handle source control at the object level. Is there >>>>>> something similar for subversion, or are you trying a workaround? >>>>>> >>>>>> Charlotte >>>>>> >>>>>> On Tue, Jul 13, 2010 at 1:35 PM, jwcolby >>>>>> <jwcolby at colbyconsulting.com> >>> wrote: >>>>>>> I am wondering whether we could put together subversion and Access >>>>>>> to >>> do source control. >>>>>>> Max's eatbloat will export and import most things Access into a >>> directory structure. Subversion >>>>>>> could be used to move that stuff into version control. Once in >>> subversion, we might be able to do >>>>>>> differencing etc. >>>>>>> >>>>>>> Whaddayathink? >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> John W. Colby >>>>>>> www.ColbyConsulting.com >>>>>>> -- >>>>>>> AccessD mailing list >>>>>>> AccessD at databaseadvisors.com >>>>>>> http://databaseadvisors.com/mailman/listinfo/accessd >>>>>>> Website: http://www.databaseadvisors.com >>>>>>> >>>>> -- >>>>> AccessD mailing list >>>>> AccessD at databaseadvisors.com >>>>> http://databaseadvisors.com/mailman/listinfo/accessd >>>>> Website: http://www.databaseadvisors.com >>>>> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > >