How to generate SQL (INSERT) Script for existing data in MS SQL Server

• Select the Database in SQL Server Management Studio (SSMS)
• Right Click on the Database
• Select Tasks then Generate Scripts
• In “Generate and Publish Scripts” wizard
• Select the required tables
• In “set Scripting Options” window select “Advanced”
• Under General tab
o Types of data to script Select the value as “Data Only”