I looked at a demo video for this http://www.red-gate.com/products/sql-development/sql-source-control/
<http://www.red-gate.com/products/sql-development/sql-source-control/>It looks promising. I have not tried it myself but the idea of version control in DB's is awesome. Yes, you can create a folder in root and maintain sql code there but nothing like maintaining code/procs via SSMS. Which version of SQL Server are you using? <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Wed, Apr 13, 2011 at 6:02 PM, Billy Cravens <[email protected]> wrote: > 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 > -- 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
