In this article i would like to share how to generate script file in sql server 2008 r2. Hope it will help mostly to freshers.
In order to see the full and clear image click on the respected images.
Step 1: Right click on the database from which you want to generate the script. You’ll find the screen as below.
Step 2: After selecting generate scripts, Generate script wizard will open.Click on Next Button.
Step 3: By default the radio button checked for select all database objects. If you want to generate the script only for some specific table then select below radio button and check the respected check box.
Step 4: By default the script generate only schema’s of the objects. If we need data along with schema we need to click advance button select the dropdown with option schema and data only as shown in below figure.
Step 5: Give appropriate file name and click on next button and here we are ready with script file.
Step 6: Go to the folder where you saved the script file double click on it. It will directly open on SSMS just press F5 to execute the script. SIMPLE!