tool to create insert sql for table data

FAQ

Profile

tool to create insert sql for table data

Database Help (Home) -> Programming

Next: Query Calculations

Author

Message

John A Grandy

External

Since: Jun 26, 2008
Posts: 80

(Msg. 1) Posted: Fri Oct 03, 2008 2:39 pm
Post subject: tool to create insert sql for table data
Archived from groups: microsoft>public>sqlserver>programming (more info?)

I need a tool to create insert sql for all data in a table ...

So, this tool would generate one insert statement for each row in the table.

Does such a beast exist ?

>> Stay informed about: tool to create insert sql for table data

Plamen Ratchev

External

Since: Aug 20, 2008
Posts: 672

(Msg. 2) Posted: Fri Oct 03, 2008 5:48 pm
Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Here is a method using stored procedure:
http://vyaskn.tripod.com/code.htm#inserts

--
Plamen Ratchev
http://www.SQLStudio.com

>> Stay informed about: tool to create insert sql for table data

mouser

External

Since: Sep 30, 2008
Posts: 44

(Msg. 3) Posted: Fri Oct 03, 2008 6:25 pm Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: > I need a tool to create insert sql for all data in a table ... > > So, this tool would generate one insert statement for each row in the > table. > > Does such a beast exist ? I have used a few, but they usually turn into paid products. I liked the one at http://www.sqlscripter.com but it became rather expensive for the level of polish. Also, there is one at http://www.codeplex.com/sqlgen which is free but does have a few bugs.... >> Stay informed about: tool to create insert sql for table data

Tom Cooper

External

Since: Jan 10, 2008
Posts: 463

(Msg. 4) Posted: Fri Oct 03, 2008 6:25 pm Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Another free one is at http://vyaskn.tripod.com/code.htm#inserts Tom "mouser" wrote in message > > On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: > >> I need a tool to create insert sql for all data in a table ... >> >> So, this tool would generate one insert statement for each row in the >> table. >> >> Does such a beast exist ? > > I have used a few, but they usually turn into paid products. I liked the > one at http://www.sqlscripter.com but it became rather expensive for the > level of polish. Also, there is one at http://www.codeplex.com/sqlgen > which > is free but does have a few bugs.... >> Stay informed about: tool to create insert sql for table data

John A Grandy

External

Since: Jun 26, 2008
Posts: 80

(Msg. 5) Posted: Fri Oct 03, 2008 6:25 pm Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

I'm using SQL Scripter ... On problem I am coming across is how to renumber identity column values. Easy for a solitary table ... just remove the identity col from the select list and gen the script ... But what if there's a 2nd table with an FK join to the first table ... "Tom Cooper" wrote in message > Another free one is at http://vyaskn.tripod.com/code.htm#inserts > > Tom > > "mouser" wrote in message > >> >> On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: >> >>> I need a tool to create insert sql for all data in a table ... >>> >>> So, this tool would generate one insert statement for each row in the >>> table. >>> >>> Does such a beast exist ? >> >> I have used a few, but they usually turn into paid products. I liked the >> one at http://www.sqlscripter.com but it became rather expensive for the >> level of polish. Also, there is one at http://www.codeplex.com/sqlgen >> which >> is free but does have a few bugs.... > > >> Stay informed about: tool to create insert sql for table data

mouser

External

Since: Sep 30, 2008
Posts: 44

(Msg. 6) Posted: Fri Oct 03, 2008 8:26 pm Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: > I'm using SQL Scripter ... > > On problem I am coming across is how to renumber identity column values. > > Easy for a solitary table ... just remove the identity col from the select > > list and gen the script ... > > But what if there's a 2nd table with an FK join to the first table ... > > > "Tom Cooper" wrote in message > > > Another free one is at http://vyaskn.tripod.com/code.htm#inserts > > > > Tom > > > > "mouser" wrote in message > > > >> > >> On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: > >> > >>> I need a tool to create insert sql for all data in a table ... > >>> > >>> So, this tool would generate one insert statement for each row in the > >>> table. > >>> > >>> Does such a beast exist ? > >> > >> I have used a few, but they usually turn into paid products. I liked > >> the > >> one at http://www.sqlscripter.com but it became rather expensive for > >> the > >> level of polish. Also, there is one at http://www.codeplex.com/sqlgen > >> which > >> is free but does have a few bugs.... > > > > I'm not sure the tool was intended to do that. It attempts to generate the scripts for the tables you have chosen verbatim. >> Stay informed about: tool to create insert sql for table data

John A Grandy

External

Since: Jun 26, 2008
Posts: 80

(Msg. 7) Posted: Fri Oct 03, 2008 8:26 pm Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Sure , I don't expect the tool to do this for me ... But this is a tricky problem , because with huge datasets , if you extract sub-portions of data ( for example a single user's data ) and seed it into a new db , your identity columns have all sorts of gaps ... "mouser" wrote in message > > On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: > >> I'm using SQL Scripter ... >> >> On problem I am coming across is how to renumber identity column values. >> >> Easy for a solitary table ... just remove the identity col from the >> select >> >> list and gen the script ... >> >> But what if there's a 2nd table with an FK join to the first table ... >> >> >> "Tom Cooper" wrote in message >> >> > Another free one is at http://vyaskn.tripod.com/code.htm#inserts >> > >> > Tom >> > >> > "mouser" wrote in message >> > >> >> >> >> On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: >> >> >> >>> I need a tool to create insert sql for all data in a table ... >> >>> >> >>> So, this tool would generate one insert statement for each row in the >> >>> table. >> >>> >> >>> Does such a beast exist ? >> >> >> >> I have used a few, but they usually turn into paid products. I liked >> >> the >> >> one at http://www.sqlscripter.com but it became rather expensive for >> >> the >> >> level of polish. Also, there is one at http://www.codeplex.com/sqlgen >> >> which >> >> is free but does have a few bugs.... >> > >> > > > I'm not sure the tool was intended to do that. It attempts to generate > the > scripts for the tables you have chosen verbatim. >> Stay informed about: tool to create insert sql for table data

mouser

External

Since: Sep 30, 2008
Posts: 44

(Msg. 8) Posted: Fri Oct 03, 2008 10:26 pm Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: > Sure , I don't expect the tool to do this for me ... > > But this is a tricky problem , because with huge datasets , if you extract > > sub-portions of data ( for example a single user's data ) and seed it into > a > new db , your identity columns have all sorts of gaps ... > > > "mouser" wrote in message > > > > > On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: > > > >> I'm using SQL Scripter ... > >> > >> On problem I am coming across is how to renumber identity column > >> values. > >> > >> Easy for a solitary table ... just remove the identity col from the > >> select > >> > >> list and gen the script ... > >> > >> But what if there's a 2nd table with an FK join to the first table ... > >> > >> > >> "Tom Cooper" wrote in message > >> > >> > Another free one is at http://vyaskn.tripod.com/code.htm#inserts > >> > > >> > Tom > >> > > >> > "mouser" wrote in message > >> > > >> >> > >> >> On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> > >> >> wrote: > >> >> > >> >>> I need a tool to create insert sql for all data in a table ... > >> >>> > >> >>> So, this tool would generate one insert statement for each row in > >> >>> the > >> >>> table. > >> >>> > >> >>> Does such a beast exist ? > >> >> > >> >> I have used a few, but they usually turn into paid products. I > >> >> liked > >> >> the > >> >> one at http://www.sqlscripter.com but it became rather expensive for > >> >> the > >> >> level of polish. Also, there is one at > >> >> http://www.codeplex.com/sqlgen > >> >> which > >> >> is free but does have a few bugs.... > >> > > >> > > > > > I'm not sure the tool was intended to do that. It attempts to generate > > the > > scripts for the tables you have chosen verbatim. I'm not sure what to say. Can you tell us why you need to renumber the identity column? mouser >> Stay informed about: tool to create insert sql for table data

Eric Isaacs

External

Since: May 13, 2008
Posts: 367

(Msg. 9) Posted: Sat Oct 04, 2008 1:44 pm Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Stepping back a little, why do you need individual inserts for each row? Are you attempting to duplicate the table and all it's data? Is it within the same database, or a connected database? Do you need to script the creating of the tables, relationships, and the data for an install? Look into the tools from Red-Gate Software. http://www.red-gate.com/ Their SQL Packager might be just what your looking for. All the tools have a free trial period. -Eric Isaacs >> Stay informed about: tool to create insert sql for table data

Jacob Sebastian

External

Since: Aug 18, 2008
Posts: 21

(Msg. 10) Posted: Sun Oct 05, 2008 11:25 am Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

And, If you have the management studio (SSMS) of SQL Server 2008, go to "generate scripts" option and select your tables. You have an option to "script data", which will generate the insert statements that you can use to move the data. -- Jacob Sebastian SQL Server MVP http://www.sqlserverandxml.com "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message > I need a tool to create insert sql for all data in a table ... > > So, this tool would generate one insert statement for each row in the > table. > > Does such a beast exist ? > >> Stay informed about: tool to create insert sql for table data

Thomas49

External

Since: Aug 14, 2004
Posts: 11

(Msg. 11) Posted: Fri Dec 19, 2008 3:41 am Post subject: RE: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Try http://www.sqlscripter.com to generate data scripts. Insert, Update, Delete + mix are supported. "John A Grandy" wrote: > I need a tool to create insert sql for all data in a table ... > > So, this tool would generate one insert statement for each row in the table. > > Does such a beast exist ? > > > >> Stay informed about: tool to create insert sql for table data

Optillect Team

External

Since: Apr 12, 2011
Posts: 1

(Msg. 12) Posted: Tue Apr 12, 2011 5:25 pm Post subject: Re: tool to create insert sql for table data [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Let us suggest Optillect Data Compare SQL. It has special option "Full data transfer mode", which allows to generate all INSERTs for all or particular tables or/and views in your database. Moreover, you can exclude columns and rows you need! Check it out at http://optillect.com/products/datacomparesql/overview.html > On Friday, October 03, 2008 5:39 PM John A Grandy wrote: > I need a tool to create insert sql for all data in a table ... > > So, this tool would generate one insert statement for each row in the table. > > Does such a beast exist ? >> On Friday, October 03, 2008 5:43 PM mouser wrote: >> On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: >> >> >> I have used a few, but they usually turn into paid products. I liked the >> one at http://www.sqlscripter.com but it became rather expensive for the >> level of polish. Also, there is one at http://www.codeplex.com/sqlgen which >> is free but does have a few bugs.... >>> On Friday, October 03, 2008 5:48 PM Tom Cooper wrote: >>> Another free one is at http://vyaskn.tripod.com/code.htm#inserts >>> >>> Tom >>>> On Friday, October 03, 2008 5:48 PM Plamen Ratchev wrote: >>>> Here is a method using stored procedure: >>>> http://vyaskn.tripod.com/code.htm#inserts >>>> >>>> -- >>>> Plamen Ratchev >>>> http://www.SQLStudio.com >>>>> On Friday, October 03, 2008 7:48 PM John A Grandy wrote: >>>>> I'm using SQL Scripter ... >>>>> >>>>> On problem I am coming across is how to renumber identity column values. >>>>> >>>>> Easy for a solitary table ... just remove the identity col from the select >>>>> list and gen the script ... >>>>> >>>>> But what if there's a 2nd table with an FK join to the first table ... >>>>> >>>>> >>>>> "Tom Cooper" wrote in message >>>>> >>>>>> On Friday, October 03, 2008 8:17 PM mouser wrote: >>>>>> On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: >>>>>> >>>>>> >>>>>> I am not sure the tool was intended to do that. It attempts to generate the >>>>>> scripts for the tables you have chosen verbatim. >>>>>>> On Friday, October 03, 2008 9:37 PM John A Grandy wrote: >>>>>>> Sure , I don't expect the tool to do this for me ... >>>>>>> >>>>>>> But this is a tricky problem , because with huge datasets , if you extract >>>>>>> sub-portions of data ( for example a single user's data ) and seed it into a >>>>>>> new db , your identity columns have all sorts of gaps ... >>>>>>> >>>>>>> >>>>>>> "mouser" wrote in message >>>>>>> >>>>>>>> On Friday, October 03, 2008 9:46 PM mouser wrote: >>>>>>>> On 3-Oct-2008, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: >>>>>>>> >>>>>>>> >>>>>>>> I am not sure what to say. Can you tell us why you need to renumber the >>>>>>>> identity column? >>>>>>>> >>>>>>>> mouser >>>>>>>>> On Sunday, October 05, 2008 6:24 AM Eric Isaacs wrote: >>>>>>>>> Stepping back a little, why do you need individual inserts for each >>>>>>>>> row? Are you attempting to duplicate the table and all it's data? Is >>>>>>>>> it within the same database, or a connected database? Do you need to >>>>>>>>> script the creating of the tables, relationships, and the data for an >>>>>>>>> install? >>>>>>>>> >>>>>>>>> Look into the tools from Red-Gate Software. http://www.red-gate.com/ >>>>>>>>> Their SQL Packager might be just what your looking for. All the tools >>>>>>>>> have a free trial period. >>>>>>>>> >>>>>>>>> -Eric Isaacs >>>>>>>>>> On Sunday, October 05, 2008 10:45 AM Jacob Sebastian wrote: >>>>>>>>>> And, If you have the management studio (SSMS) of SQL Server 2008, go to >>>>>>>>>> "generate scripts" option and select your tables. You have an option to >>>>>>>>>> "script data", which will generate the insert statements that you can use to >>>>>>>>>> move the data. >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Jacob Sebastian >>>>>>>>>> SQL Server MVP >>>>>>>>>> http://www.sqlserverandxml.com >>>>>>>>>> >>>>>>>>>> "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message >>>>>>>>>> >>>>>>>>>>> On Friday, December 19, 2008 6:41 AM Thoma wrote: >>>>>>>>>>> Try http://www.sqlscripter.com to generate data scripts. Insert, Update, >>>>>>>>>>> Delete + mix are supported. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> "John A Grandy" wrote: >> Stay informed about: tool to create insert sql for table data

Display posts from previous:

Related Topics:

insert into table without all data fields? - Hi, I'm working on modifying a stored procedure used to provide data for a crystal report. The summarized code is as follows: CREATE TABLE #selected_agents ( agentloginid nvarchar(50), agentname nvarchar(50), agentID int, profileid int,..

Create table with data on the fly - How create a temp table and populate it with dates for a given period? Thanks

Get data from three table and insert it in new table - Hi, I am using ASP with SQL Server200. I am getting data from three tables then showing result. Its performance is not good. I want to use store procedure for this. IWhat I am doing in ASP SQL = "Select Custid, BranchId, purchord, PCode, descri...

SQL 2005: How to generate INSERT statement for the data wi.. - Hi, Using SQL 2005, what would be the best way to generate INSERT statement for all data within one table or all tables within our database? Any help would be appreciated, Max

a cool new free tool: data monitoring - Hi, we wanted to let people know of a new tool we are giving 100% for free - no strings, no catches, just looking for feedback on it. a bit like SQL Server Profiler, it helps you monitor data changes in sql server. basically, you proide one or more..

	Database Help (Home) -> Programming	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum