SEO

#1 (**permalink**) 02-28-2008, 07:26 PM

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

#2 (**permalink**) 02-28-2008, 07:27 PM

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@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

#3 (**permalink**) 02-28-2008, 07:27 PM

"Tim Morrison" <sales@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

#4 (**permalink**) 02-28-2008, 07:27 PM

Looks like ObjectScriptr is just what im looking for.

Thanks,

Tim Morrison

"oj" <nospam_ojngo@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" <sales@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
>
>

#5 (**permalink**) 02-28-2008, 07:31 PM

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

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

Nick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Creating a Script out of Sample Data