Step 4

Now you will be shown a window which asks you about how your script should be published.

Database_Scripts_With_Data_Publish_Options

Click advanced in that window.

Step 5

Select ‘Schema and data’ from type of data to script option and then click OK.

Database_Scripts_With_Data_Advanced

Click next.

Step 6

Click finish, now check the script file, it must be having the insert queries too.

Screenplay

Database_Scripts_With_Data_Finish

Now what else is pending, go ahead and run your script.

Conclusion

Did I miss anything that you may think which is needed? Have you ever wanted to do this requirement? Could you find this post as useful? I hope you liked this article. Please share me your valuable suggestions and feedback.

Your Turn. What Do You Think?

A blog isn’t a blog without comments, but do try to stay on topic. If you have a question unrelated to this post, you’re better off posting it on C# Corner, Code Project, Stack Overflow, Asp.Net Forum instead of commenting here. Tweet or email me a link to your question there and I’ll definitely try to help if I can. And you can find more of my thoughts on SQL here:

Film Scripts Free Pdf Download

Like This Article? Read More From DZone

sql server ,script ,data ,tutorial ,database
Published at DZone with permission of Sibeesh Venu , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.