How to backup table’s data with Sql Server 2008?

Some time it can be useful to dump all data of a table in the format of SQL insert statement.

This can be done easily with Microsoft SQL Management Studio. The first step is to right click on the database and select the option Task>Generate Script. This will popup a wizard window.

Microsoft Sql Management Studio Generate scripts

The last step is to select that we desire only the data.

Select data to get all information of the table without creating the schema

This will produce all SQL’s insert statement with your data.

If you like my article, think to buy my annual book, professionally edited by a proofreader. directly from me or on Amazon. I also wrote a TypeScript book called Holistic TypeScript

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.