• 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”
