SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements.
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/errors * 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 cames with SQL Server by default.
