SQL Inserter was developed to be a Winform Application written in C# using Visual Studio 2008. Generates SQL Insert scripts from existing Database. Can handle SQL2000 - 2008.

Supports datatype binary and geography. You need to have SQL Server 2008 SDK installed. I use it a lot for generating data for unittests and for transfering data between servers.

Connect to a server, choose tables to generate data from and let the Sql Inserter generate Scripts in the form "Insert Into table (col1,col2) values('val1','val2'). Choose "order by dependency" if your data needs to be scripted in a way that no constraints are violated.