Generate script for data

Question

Generate script for data

Viewing 3 posts - 16 through 17 (of 17 total)

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

Stevo Smocilac Mr or Mrs. 500 Points: 564 More actions · Answer 1

Microsoft has just released a tool which will generate a script file containing both the schema and data of a table. It’s called the "Microsoft SQL Server Database Publishing Wizard 1.1" and you can download it here, http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en.

Regards

Stevo

jezemine SSCrazy Eights Points: 8059 More actions · Answer 2

Just wanted to plug the following: bcp.exe

it will export all the data in any table or query you care to write, and much faster to import than a .sql file with 10 million INSERT statements.

oh, btw, I am not the product manager for bcp.exe

---------------------------------------
elsasoft.org

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

Now, there's a plug I can agree with... AND, if you take the time to study it in Books OnLine, you'll find that it's capable of doing such things as allow "good" lines in and saving "bad" lines in a separate file for reconciliation, can import/export flat files and delimited files, has a "format file" that you can use (very worth getting good at that), and is nasty fast in either direction. The only thing faster for imports is BULK INSERT (can use the same format file) but that's because it can't write bad lines to an error file, etc.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions