用于 sqlserver Management Studio 编写行插入脚本的简单插件或过程
我一直无法为 sql server Management Studio（2005 和/或 2008）找到一个好的脚本或插件来满足非常常见的脚本需求：指定表中的一些/所有行并为其插入编写脚本。您可以猜到我的故事：我的开发数据库中有一些配置数据，我需要编写脚本以部署到 UAT，然后进行生产。
我过去发现过一些笨拙的系统，它们带来的麻烦超过了它们的价值。我需要一些免费并且不引人注目的东西。一旦我找到它，我就会与我店里其他 20 位对此感到恼火的开发者分享。顺便说一句，我们不是都对此感到恼火吗？
指定表中的一些/所有行并获取插入脚本的最佳、最简单、免费的方法是什么？
编辑
分辨率：SSMS 工具包太棒了！这正是我所寻找的：免费、不引人注目、简单、可靠。它还有很多其他方便的补充，我期待着探索。
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 for 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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
SMSS 工具包 可以做到这一点。有点。
The SMSS Tools Pack can do this. Sorta.
您可以使用 RedGate Data Compare 跨数据库比较表。它将为您生成插入内容。
You can use RedGate Data Compare to compare table(s) across databases. It will generate inserts for you.
每当我们向 dev 中的查找表添加行时，我们都会在插入脚本中执行此操作，该脚本会像项目的其余部分一样放入源代码管理中。然后该脚本作为部署的一部分运行。
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.