That would be cool if they do .. right now I'm having to hand-code these. I love all of the Red Gate tools, but never could justify the cost (or find someone to buy them for me)
Billy Cravens On Wed, Apr 13, 2011 at 5:00 PM, John M Bliss <[email protected]> wrote: > P.S. I'm pretty sure that the RedGate tools I mentioned auto-do this. > > > On Wed, Apr 13, 2011 at 4:56 PM, Billy Cravens <[email protected]>wrote: > >> I would add that you want your scripts to be fully independent. By this, I >> mean you want to be able to run the script as many times as needed, on >> whatever environment you're running (local dev, staging server, production >> server, etc.). I know when I don't do this, I often overlook errors in my >> SQL script because my schema is already in place. To this end, you'll want >> to check for table/column/trigger/etc, drop it if it exists, then create it. >> This is a bit overkill perhaps, but it'll help you flesh out problems with >> your schema designs and scripts (reliance on specific ID's for example). A >> well written script can be run an infinite number of times without breaking >> the app (data changes notwithstanding, of course - but even this should be >> caught if you have proper relationship constraints). >> >> You haven't lived until you've dropped a default value constraint in SQL >> Server without hard-coding (they are given random names when you create a >> column default, and you can't drop a column until you drop the constraint) >> >> Billy Cravens >> >> >> >> 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 >> >> >> -- >> 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 > -- 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
