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]

Re: Creating a Script out of Sample Data

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" <sales@kjmsoftw are.com> wrote in message
news:J%1Lb.7617 23$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]

Re: Creating a Script out of Sample Data

"Tim Morrison" <sales@kjmsoftw are.com> wrote in message news:<J%1Lb.761 723$HS4.6022647 @attbi_s01>...[color=blue]
> 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
> --[/color]

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]

Re: Creating a Script out of Sample Data

Looks like ObjectScriptr is just what im looking for.

Thanks,

Tim Morrison

"oj" <nospam_ojngo@h ome.com> wrote in message
news:JN7Lb.7819 98$Fm2.760879@a ttbi_s04...[color=blue]
> 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" <sales@kjmsoftw are.com> wrote in message
> news:J%1Lb.7617 23$HS4.6022647@ attbi_s01...
> SQL Server 2000
>
> Is there any way to take sample data in my database and create an INSERT[/color]
INTO[color=blue]
> script?
>
> I have a commercial application that I would like to include sample data,[/color]
and[color=blue]
> instead of restoring a backup like I am doing now, I would like to first[/color]
run a[color=blue]
> script that creates the database, stored procedures, etc, then run a[/color]
script that[color=blue]
> inserts sample data if the customer so chooses.
>
> I know I can do this manually, but is there any way to create the script[/color]
based[color=blue]
> on exisiting data?
>
> TIA
>
> --
> Tim Morrison
>
> --------------------------------------------------------------------------[/color]
------[color=blue]
>
> Vehicle Web Studio - The easiest way to create and maintain your vehicle[/color]
related[color=blue]
> website.
> http://www.vehiclewebstudio.com
>
>[/color]

[Thomas]

Re: Creating a Script out of Sample Data

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

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

Nick