Right-click the database , select "Tasks", "Generate
Scripts...". As you work through, you'll get to a "Scripting Options"
section. Click on "Advanced", and in the list that pops up, where it
says "Types of data to script", you've got the option to select Data
and/or Schema.

No comments:
Post a Comment