Como generar el script de las tablas incluyendo sus datos en SQL Server

https://www.youtube.com/watch?v=tS3OCkbKGx0
***************
http://stackoverflow.com/questions/10028805/transfer-data-from-one-database-to-another-database
Resumen

http://okayguru.blogspot.co.uk/2012/03/copy-one-database-to-another-database.html

There are several ways to do this, below are two options:

Option 1 - Right click on the database you want to copy

     next (introduction)

• Choose 'Tasks' > 'Generate scripts'
• ---
• 'Select specific database objects' 
• Check 'Tables'
• (EN MI CASO ELIGO LA OTRA OPCION SCRIPT ENTIRE DATABASE...)
• ----
• Mark 'Save to new query window' (el radio button)
• Click en el boton 'Advanced'
• Set 'Types of data to script'  to 'Schema and data'
• Next, Next

You can now run the generated query on the new database.

Option 2

• Right click on the database you want to copy
• 'Tasks' > 'Export Data'
• Next, Next
• Choose the database to copy the tables to
• Mark 'Copy data from one or more tables or views'
• Choose the tables you want to copy
• Finish