Scripting Data

Question

Scripting Data

TheRedneckDBA

SSChampion

Points: 14001
More actions
February 29, 2008 at 2:44 pm

#187171

Anyone know of a program that will take a table with data in it and generate the insert script for that data?
We want to create a script to totally recreate a database from scratch. The SSMS GUI does a pretty good job of scripting out all of the objects and the database itself, but not the data.
The Redneck DBA

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Red Gate probably has a tool that will do that. I know SQL Data Compare will generate the data script when doing a comparison. I don't think it will do it otherwise.

Another option is to write your own SQL Script that will do it. Here is a link to a script posted on this site just for this purpose:

http://www.sqlservercentral.com/scripts/Miscellaneous/31447/

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 2

Heh... it's not that complicated... why not just use BCP in the Native mode? If you just gotta have something to look at, it's still not that complicated... see the "Create Some Data" section in the following...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

--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)