DBScripter

DBScripter is an application to script data. Generated script contains a series of insert statement and ready to run against the target database. Features include generates ANSI or Unicode script, an optionally add drop constraints statement to drop foreign keys before deletion from table, optionally add delete statement to clear table before insertion, optionally add disable or enable trigger statements to temporarily disable triggers, automatically adds set identity insert on statement for table that has an identity column, you can specify appropriate format for date-time fields, and you can specify a condition (without WHERE keyword) for each table separately.