Here is the way where we
can take SQL database scripts as well as data with insert scripts. Just need to
follow below instructions.
Step 1: Right click on database to generate script, go to
the tasks and click on Generate Scripts.
Step 2: Select the database you want to generate the Scripts,
click next to go to choose scripts option.
Step 3: Select the Script Data to true in Table Views Option
and click next.
Step 4: Go to choose object type and select the object type i.e.
(Stored procedures/Tables), click next
Step 5: go to choose stored procedure and click next to
choose Tables
Step 6: Next screen output option will appear, click next to
see script wizard summary
Step7: Click finish to get the generated database scripts on
your query window
Comments