Easy plugin or procedure for sqlserver Management Studio to script row inserts.

Posted by Patrick Karcher on Stack Overflow See other posts from Stack Overflow or by Patrick Karcher
Published on 2010-04-15T13:52:52Z Indexed on 2010/04/15 14:33 UTC
Read the original article Hit count: 164

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?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about management-studio