In this post we will discuss about how we can generate SQL Server scripts of our database with existing data, once we generate the script, the result will give you an insert query with other queries, so that the data also will get inserted in your new database.
Full article