How to Generate Script in SQL Server 2014 with Data
In this session you can see how easy to generate script for Schema and data in SQL server.
also you can see how to generate scripts for a particular table in your SQL Server database and other scripting options
create script without removing data in sql server | data migration through script in sql server | generate database script for sql server 2014