SSMS 2008 Addin - Data Scripter

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

Recommended Download

Application Setup.zip
application, 362K, uploaded Dec 27, 2008 - 13727 downloads

Other Available Downloads

Source Code DataScripter.zip
source code, 39K, uploaded Nov 6, 2008 - 3565 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. This works with NVARCHAR Unicode values! This is great too if you don't need Unicode! http://store.nmally.com/software/sql-server-management-studio-addons/ssms-addin-scripting-tool-insert-to-t-sql.html
by trj87 on Jan 9 at 12:41 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 1: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 2: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 2: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 2:23 PM