Sql - Generate Script for Table Data

Ever needed to create a script for the records in a database table?

I found a great stored proc today that can help do just that from this site:

http://vyaskn.tripod.com/code.htm#inserts

It has like every option you could ever need in it too. A must have.

They also have a ton of other cool toys for Sql Server.

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Print | posted on Wednesday, January 21, 2004 6:03 PM

Feedback

# re: Sql - Generate Script for Table Data

left by m at 5/4/2007 6:10 AM Gravatar
thanks, saved me much time

# re: Sql - Generate Script for Table Data

left by Loloto at 6/12/2008 4:08 PM Gravatar
hu hu hu!
thanks a lot, U saved many hours.
I have been looking for something like this for a long time.
LOL

# re: Sql - Generate Script for Table Data

left by dhaval at 6/16/2008 8:38 AM Gravatar
When i am executing the above SP with columns whose total length is greater than 128 characters it is giving me an error.

My SP

EXEC sp_generate_inserts @table_name = fieldmaster, @cols_to_include = "'intReportFieldID','intReportTypeID','vcrFieldName','vcrEclerxFieldCaption','vcrCsFieldCaption','bitActive','bitEconomic','bitShow'"

The error :

The identifier that starts with ''intReportFieldID','intReportTypeID','vcrFieldName','vcrEclerxFieldCaption','vcrCsFieldCaption','bitActive','bitEconomic','bitSh' is too long. Maximum length is 128.

i know that identifiers do not take more than 128 characters but is there some other way round?? Can anyone help me with this?? Thanks in advance.

# re: Sql - Generate Script for Table Data

left by Manish K at 10/20/2008 1:53 AM Gravatar
Hi guys,

I am looking for some help, to generate the scripts of table in SQL2005 / 2008 ,
Many thanks.

Manish

# re: Sql - Generate Script for Table Data

left by May at 11/13/2008 3:55 PM Gravatar
Hi guys..

i need a way to generate a full script of a Database build in SQL Anywhere 10.0.0...including stored procedures, triggers, etc...

Thanx.

# re: Sql - Generate Script for Table Data

left by Menita at 4/15/2009 10:48 AM Gravatar
http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard

downlaod the Database publishing wizard from the above link. It can help you script database schema and data. I have used this only in SQL server DBs

# re: Sql - Generate Script for Table Data

left by Nw at 5/8/2009 5:13 AM Gravatar
Excellent post - Thanks for sharing.

# re: Sql - Generate Script for Table Data

left by Marius at 6/15/2009 6:01 AM Gravatar
This post was a great help, thanks alot guys, cudos to Narayana Vyas Kondreddi!

# re: Sql - Generate Script for Table Data

left by Tenzin at 8/4/2009 10:10 AM Gravatar
That's dude.

# re: Sql - Generate Script for Table Data

left by VINOD at 9/3/2009 11:17 PM Gravatar
Thanks mate, that saved me hell lot of time.

# re: Sql - Generate Script for Table Data

left by ashish at 9/14/2009 11:56 PM Gravatar
hey gyus i m looking for scripts in sql pls help me out

# re: Sql - Generate Script for Table Data

left by Lijo at 11/17/2009 6:05 AM Gravatar
Download and install free SSMS tools (http://www.ssmstoolspack.com/)

# re: Sql - Generate Script for Table Data

left by brian at 2/17/2010 11:20 PM Gravatar
I am using MDBScript(http://www.mdbscript.com), it works well for me.

# re: Sql - Generate Script for Table Data

left by Raef at 5/21/2010 5:31 AM Gravatar
You can use free tool Mygeneration in Microsoft SQL Server/Data/Built inserts from table

# re: Sql - Generate Script for Table Data

left by Ismady Asmavy at 6/21/2011 11:42 PM Gravatar
Thank you

# re: Sql - Generate Script for Table Data

left by siva at 8/7/2011 11:15 PM Gravatar
no coments

# re: Sql - Generate Script for Table Data

left by Md.Waseem at 10/8/2011 4:33 AM Gravatar
I want to know about,how to create script to particular database files.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: