> Do you save them inside the project root with all your code? Yes.
> I was looking at a folder one level up from our web root (but still in same svn project as code). That's what we do: "sql" is a "sibling" of the webroot. > This would keep sql code from being browse-able (good) but also means it’s out on the production web server (Maybe bad??) We copy it to our staging/shadow server but *don't* copy it to prod. On Wed, Apr 13, 2011 at 4:31 PM, Mark Davis <[email protected]> wrote: > Thanks John. Do you save them inside the project root with all your code? > I was looking at a folder one level up from our web root (but still in same > svn project as code). This would keep sql code from being browse-able > (good) but also means it’s out on the production web server (Maybe bad??) > > > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *John M Bliss > *Sent:* Wednesday, April 13, 2011 4:25 PM > *To:* [email protected] > *Subject:* Re: [houcfug] versioning SQL scripts > > > > > Anyone save db scripts in subversion > > > > Yes. > > > > > and if so, have you run into any gotchas? > > > > Not really. Not sure whether this is the best way, but we: > > 1. typically generate these with http://red-gate.com excellent SQL > Compare and SQL Data Compare products (worth every penny) > 2. save them as sql\yyyymmddhhmm.sql (where that's always in one > agreed-upon timezone despite the fact that we're in three timezones) > 3. comment them carefully in svn > > Let me know if you have any specific questions. > > > > > > On Wed, Apr 13, 2011 at 4:17 PM, Mark Davis <[email protected]> wrote: > > Hey guys, > > > > I am looking at adding database objects/scripts to subversion and just > starting from scratch. My entire development team works remotely, and > each time someone has a new db script for a task they are working on, it > typically gets emailed around so we can all update our local environments. > No real way to track changes. > > > > Anyone save db scripts in subversion and if so, have you run into any > gotchas? > > > > Thanks > > > > Mark > > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > > > > -- > John Bliss - http://about.me/jbliss > > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > ------------------------------ > > No virus found in this message. > Checked by AVG - www.avg.com > Version: 10.0.1209 / Virus Database: 1500/3571 - Release Date: 04/13/11 > > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > -- John Bliss - http://about.me/jbliss -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en
