how to generate insert statement from existing database

[damonpin]

hi,

I have a sample database which I know how to create the schema. I want to generate a sql script containing insert data statement from this sample database. I want to give the
sql script containing insert statement to client so they could regenerate the sample database. Is there an existing tool or script that can do that?

Thanks a lot for you help

 

[dickiebird]

Presumably your sample data is a text(flat) file?
So - use bcp !
eg bcp dbtablename in flatfile
This assumes a tab as field delimiter and \n as record delimeter - read up on bcp for changes to these defaualts
HTH ;-) Dickie Bird

Honi soit qui mal y pense

 

[JMCraig]

Hi,

There are other ways to deal with this if you really need an INSERT statement--although I'd recommend Dickie's approach as the simplest for sure. (Whether you personally mal y pense or not!)

Various utilities exist that will product INSERT statements from a table's data and if you'd like more info on that, you can reply again.

BOL,

John J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net

 

[RayPeck]

It sounds like you want to create a copy of your sample database onto the client's machine. Another possibility is to just Dump the sample database (dump database to "path & filename&quot, then reload it on the client. If you have the same operating system as the client, that is the easiest and most reliable. Everything will go--permissions, size, data, user datatypes, rules, defaults, etc. If you can do this, this is the way to go.