How To Copy Whole Database From One Computer To Another By Using Generate Script

What is Generate Script?
     This is a process in which we can generate the script of the existing database. And can use easily on other client system without loosing any Data.

Why it is different from import&export?
      By using Generate Script we can export whole database as well as data and script but in import & export  only we can extract the skeleton of the Database.It's a easiest way to copy database from one system to another.
 Here Are the steps to Generate Script of the database.
Step-1.
Right click on the database in sql and choose Task > Generate Script.

Step-2.
Click on  Next>

Step-3.
Choose The database for which u want to generate script.

Step-4.
In this wizard scroll below to select script data and choose "True".

Step-5.
Choose the tables and store-procedure  inside the database which u want to extract click on "Select all"

Step-6.
Click on Select all  which u want to extract.

Step-7.
Click on next

Step-9.
Click on finish.

Step-10.
Here the script wizard is complete and successfully script generated.

Step-11.
 Here save the SQL file and use this file in another system where u want to extract the database.