SQL Server Dumper enables you to dump selected SQL Server database tables into SQL Insert statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each table, or combine all selected tables into a single file. This program implements the following special features: Foreign Keys - order tables in text file in order to insert data without colisions/errorsc. Primary Key Identity - guarantees the value of the Identity field. Reference to itself - eliminates the constraint and at the end create it again Try this On NorthWind database that comes with SQL Server by default.
Version 2 allows to dump SQL queries, and features interface enhancements.