Generate Script with Data from Database

SSMS also provides the option to generate SQL script file which contains both schema and data. Right click the database and select Generate Scripts under Tasks Menu. Click Set Scripting Options on the left hand menu (in SQL Server 2008 R2) then click Advanced button, there is an option under General category named Type of data to Script which has 3 options - Schema only, Data only and Schema and Data.