How to generate SQL Insert Script?

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

In the Query Analyzer Object Browser, right-click on the table, choose 'script object to new window(or file, or clipboard) as insert'.

Greg

Thomas-142793 SSC Enthusiast Points: 151 More actions · Answer 2

Try http://www.sqlscripter.com to generate your data script. All types are supported (Insert, Update, Delete).

It's free.

-Thomas

Marian Chicu SSC Veteran Points: 254 More actions · Answer 3

And also DB Ghost with its Data and Schema Scripter.

I'd cry, but I can't stop laughing.