0

Is there a way to dump the content of a few SQL Server tables into a file consisting of standard INSERT INTO statements of my SQL Server database?

Improve this question
3
  • As a one-off or programmatically? Commented Jun 29, 2011 at 12:04
  • Duplicate: stackoverflow.com/q/422847/532498 Commented Jun 29, 2011 at 12:08
  • Yeah, a one-time dump from mssql to another db Commented Jun 29, 2011 at 12:11

2 Answers 2

Reset to default
1

You can use Ms Sql Publisher wizard . This will help you to create scripts based on your database schema, data or even both. Please check this link if you want to do it in Visual Studio 2008

Also, there is this article on codeproject which uses Ms Sql Publisher Wizard

A step by step process to support my answer.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Yes I found this, I was just very surprised that it didn't support it out of the box
1

If you need it as one-off, look here http://www.codeproject.com/KB/database/sqlinsertupdategenerator.aspx

Improve this answer

1 Comment

Cheers, but it seems to be having serious problems such as not supporting datetime columns

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.