dump data into SQL script as "insert ..."

#1

I am wondering if there is an easy way to script data into script.

i.e. I want to create a script file. For each record in each table, I'll
have a sql script like

INSERT INTO MyTable1 (Col1, Col2, Col3)VALUES(1, 'myVal11', 'myval12')
INSERT INTO MyTable1 (Col1, Col2, Col3)VALUES(2, 'myVal21', 'myval22')
....

I know I can do it in Oracle but I could get it in SQL Server by scripting
DB objects.

Frank

#2

This might be what you are looking for

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

Allan

"frank" <frank (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am wondering if there is an easy way to script data into script.

i.e. I want to create a script file. For each record in each table, I'll
have a sql script like

INSERT INTO MyTable1 (Col1, Col2, Col3)VALUES(1, 'myVal11', 'myval12')
INSERT INTO MyTable1 (Col1, Col2, Col3)VALUES(2, 'myVal21', 'myval22')
...

I know I can do it in Oracle but I could get it in SQL Server by
scripting
DB objects.

Frank

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

dump data into SQL script as "insert ..."

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

dump data into SQL script as "insert ..." - 09-12-2005 , 05:39 PM

Re: dump data into SQL script as "insert ..." - 09-12-2005 , 05:49 PM