469,106 Members | 2,099 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

Creating a Script out of Sample Data

SQL Server 2000

Is there any way to take sample data in my database and create an INSERT INTO script?

I have a commercial application that I would like to include sample data, and instead of restoring a backup like I am doing now, I would like to first run a script that creates the database, stored procedures, etc, then run a script that inserts sample data if the customer so chooses.

I know I can do this manually, but is there any way to create the script based on exisiting data?

TIA

--
Tim Morrison

--------------------------------------------------------------------------------

Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.
http://www.vehiclewebstudio.com
Jul 20 '05 #1
4 4018
oj
Tim,

You can use our free tool, QALite or ObjectScriptr to generate insert
statements. You can download it from site.

--
-oj
http://www.rac4sql.net
"Tim Morrison" <sa***@kjmsoftware.com> wrote in message
news:J%1Lb.761723$HS4.6022647@attbi_s01...
SQL Server 2000

Is there any way to take sample data in my database and create an INSERT INTO
script?

I have a commercial application that I would like to include sample data, and
instead of restoring a backup like I am doing now, I would like to first run a
script that creates the database, stored procedures, etc, then run a script that
inserts sample data if the customer so chooses.

I know I can do this manually, but is there any way to create the script based
on exisiting data?

TIA

--
Tim Morrison

--------------------------------------------------------------------------------

Vehicle Web Studio - The easiest way to create and maintain your vehicle related
website.
http://www.vehiclewebstudio.com
Jul 20 '05 #2
"Tim Morrison" <sa***@kjmsoftware.com> wrote in message news:<J%1Lb.761723$HS4.6022647@attbi_s01>...
SQL Server 2000

Is there any way to take sample data in my database and create an INSERT
INTO script?

I have a commercial application that I would like to include sample
data, and instead of restoring a backup like I am doing now, I would
like to first run a script that creates the database, stored procedures,
etc, then run a script that inserts sample data if the customer so
chooses.

I know I can do this manually, but is there any way to create the script
based on exisiting data?

TIA

--
Tim Morrison

-------------------------------------------------------------------------
-------

Vehicle Web Studio - The easiest way to create and maintain your vehicle
related website.
http://www.vehiclewebstudio.com
--


You could use BCP/DTS to load the sample data from external files, but
if you want to use pure TSQL, then this is one possibility:

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

Simon
Jul 20 '05 #3
Looks like ObjectScriptr is just what im looking for.

Thanks,

Tim Morrison

"oj" <no**********@home.com> wrote in message
news:JN7Lb.781998$Fm2.760879@attbi_s04...
Tim,

You can use our free tool, QALite or ObjectScriptr to generate insert
statements. You can download it from site.

--
-oj
http://www.rac4sql.net
"Tim Morrison" <sa***@kjmsoftware.com> wrote in message
news:J%1Lb.761723$HS4.6022647@attbi_s01...
SQL Server 2000

Is there any way to take sample data in my database and create an INSERT INTO script?

I have a commercial application that I would like to include sample data, and instead of restoring a backup like I am doing now, I would like to first run a script that creates the database, stored procedures, etc, then run a script that inserts sample data if the customer so chooses.

I know I can do this manually, but is there any way to create the script based on exisiting data?

TIA

--
Tim Morrison

-------------------------------------------------------------------------- ------
Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.
http://www.vehiclewebstudio.com

Jul 20 '05 #4
Hi !
Try http://www.sqlscripter.com

This tool is able to create INSERT, UPDATE and DELETE commands.

Nick
Jul 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Joshua Beall | last post: by
1 post views Thread by Don Stefani | last post: by
2 posts views Thread by Kris | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.