In SQL Server Management Studio we have option of generating Transact-SQL scripts for multiple objects or for an individual object by using the Generate and Publish Scripts Wizard.
We can save full database into a single text file related to queries for future uses like self-Practicing, Training to others, source code saving for development work or for backup purposes, etc.
Script generation of Individual Object can be possible as in the following,
Right click on a selected Table then select Script Table as option, further select script query option and click on File option to save text file on a selected location.
Now for
Database Script Generation: Select the
Database first, here I’m selecting
Trainee as a Database, then select
Tasks. Now click on
Generate Scripts as in the following,
Now click on
Next and
a new Wizard will open as in the following,
You can select option of
Script Entire Database Objects or you can specify
database objects for script generation like Table, Views, Stored Procedure or Functions.
I clicked on
Entire database and pressed
Next, A window will be displayed as shown below, Provide
file saving Path/Destination. Click on
Next now: It will open a window with
Review Your Selections options:
Now press on
Next: Saving Scripts
Confirmation actions will be displayed and press
Finish to close window.