I've never been able to find a good script or plugin for sql server Management Studio (2005 and or 2008) for a very common scripting need: specifying a few/all rows in a table and scripting their insert. You can guess my story: I've got some configuration data in my dev db and I need to script it fo开发者_如何转开发r deployment to UAT and then production.
I've found a few cludgy systems in the past, that were more trouble than they were worth. I need something free and unobtrusive. Once I find it I'll share it with the other 20 developers in my shop who are annoyed by this. Aren't we all annoyed by this by the way?
What is the best, easiest, free, way to specify a few/all rows in a table and get a script their insert?
Edit
Resolution: SSMS Tools Pack rocks! Just what I was looking for: free, unobtrusive, simple, solid. It's got a lot of other handy additions too that I look forward to exploring.
The SMSS Tools Pack can do this. Sorta.
You can use RedGate Data Compare to compare table(s) across databases. It will generate inserts for you.
Well anytime we add rows to a lookup table in dev, we do it in an insert script which is put into source control like the rest of the project. Then the script is run as part of deployment.
精彩评论