tag:blogger.com,1999:blog-5716364009216068026.post405001292885385008..comments2024-03-05T02:36:50.891-08:00Comments on Adam Tuliper's Development Tips: Executing many scripts at once in Sql Mangement StudioAdam Tuliperhttp://www.blogger.com/profile/10069537457575128626noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5716364009216068026.post-74217615609324985952009-11-16T10:46:06.433-08:002009-11-16T10:46:06.433-08:00ah yes... we had a similar debate at work. First o...ah yes... we had a similar debate at work. First off.. red gates products rock and I recommend them to just about every company I go to. However in some cases diff scripts wont cut it. You may have several developers working on separate scripts. There may be 'add ons' to the system in different departments and you may only want to script what you _know_ are your changes.. IE what exists in a specific source control branch. In a situation with us, we have to have individual files that another department will use (a build team) to create the environment. Simple diff scripts don't tell us if what we have in our source control environment is correct or not. So.. in our case everything is 'sourced' from source control. However your products have come in handy in our corporate environment to compare after the deployment, and actually at my prior company we used them for deployments - just a different procedure now. thanks!Adam Tuliperhttps://www.blogger.com/profile/10069537457575128626noreply@blogger.comtag:blogger.com,1999:blog-5716364009216068026.post-4907741047604095882009-10-22T10:25:07.328-07:002009-10-22T10:25:07.328-07:00As you own the SQL Toolbelt, you could use SQL Com...As you own the SQL Toolbelt, you could use SQL Compare's 'compare-to-scripts' feature to compare the stored procedure scripts against your DB. This assumes they're held in .sql files. SQL Compare will let you apply the changes directly or generate a single synchronization script that you can run later. Please contact me if you have any trouble getting this to work and I'll be glad to help!<br /><br />David Atkinson (David dot Atkinson at Red-Gate.com)David Atkinsonhttps://www.blogger.com/profile/07670259127619107158noreply@blogger.com