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
