SSMS 2008 Addin - Data Scripter

Rating:        Based on 6 ratings
Reviewed:  5 reviews
Downloads: 15648
Released: Nov 6, 2008
Updated: Dec 27, 2008 by iucon
Dev status: Beta Help Icon

Recommended Download

application, 362K, uploaded Dec 27, 2008 - 12282 downloads

Other Available Downloads

Source Code
source code, 39K, uploaded Nov 6, 2008 - 3366 downloads

Release Notes

This Addin for SQL Server Management Studio 2008 allows you to generate INSERT statements for all values of a table easily. Just select Script Data as from the context menu of the table and choose one of the options
  • INSERT: Insert statements without column names are generated
  • INSERT with column names: should by obvious ;-)

Reviews for this release

Found a much more useful tool that does INSERT data to MSSQL, MySQL, CSV, XML, and TEXT.
by tiffanyjordan on Apr 22, 2012 at 4:50 AM
Excellent add-in! Note that it doesn't quite work with Unicode (NVARCHAR) data; when scripting those out it should add the "N" prefix, like "insert... values (N'영語', 0, 1)".
by dnewton on Feb 17, 2011 at 2:48 AM
This is really cool. I found that it wouldn't parse the data properly if it contains single quotes. But it really works.
by PTWton on Nov 16, 2009 at 3:08 AM
Cool!!! It works well. If possible, I want your Addin in SSMS 2005 as well. And a bug i founded, it can't handle varbinary type.
by tsohr on Sep 18, 2009 at 3:06 AM
Excellent code for anybody thinking of creating a SSMS addin. (And Data Scripter is a very useful add-in)
by ErikEJ on Aug 19, 2009 at 3:23 PM