Creating a Script out of Sample Data

[Tim Morrison]

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

[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

[Simon Hayes]

"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

[Tim Morrison]

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

[Thomas]

Hi !
Try http://www.sqlscripter.com

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

Nick