Generate insert statements from the specific table data using SQL Server

8/8/2014 7:17:03 AM


When you are deploying your application, sometimes you may want to generate SQL script with the insert statement of the specific database table. In this article I will show you two easiest ways to do this with SQL Server and SQL Server tools. 1. Using Database Publishing Wizard (“SqlPubWiz.exe”) If you install Visual studio 2008 / Visual Studio 2008 Express full version, it will automatically install the Microsoft SQL Server Data Publishing Wizard on the following location. ..