squirrel-sql-users

[Squirrel-sql-users] Exporting all rows in a table to an sql file

[Susan C. <hom...@ya...>]

Hi,
 
I've looked in the documentation and the archives on a way to do this, but I've either missed it
or maybe it can not be done - I'm hoping someone can help.
 
I'm trying to figure out how to export all of the data in a table to a 'load' file - something that
has delimeters that are appropriate for import.
 
I tried all of the "Copy ..." functions available after selecting all rows and none seem to just
export the data.
 
Is there a command to do this, or do I need to use the SQL window to issue the SQL command
manually for my specific database (Derby)?
 
Thanks for your help!
 
Susan

Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file

[Gerd W. <bir...@t-...>]

Hi Susan,

at the moment SQuirreL does not offer exactly what you ask for. But it will 
maybe already in the 2.3 final release.

All we can offer now is to export the content of an SQL result table. If your 
tables are small enough to be displayed by SQuirreL you may use this function. 
You need to have version 2.3 rc1. Then just right mouse click a result and 
choose the "export CSV" item.

Gerd

Susan Cline wrote:
> Hi,
>  
> I've looked in the documentation and the archives on a way to do this, but I've either missed it
> or maybe it can not be done - I'm hoping someone can help.
>  
> I'm trying to figure out how to export all of the data in a table to a 'load' file - something that
> has delimeters that are appropriate for import.
>  
> I tried all of the "Copy ..." functions available after selecting all rows and none seem to just
> export the data.
>  
> Is there a command to do this, or do I need to use the SQL window to issue the SQL command
> manually for my specific database (Derby)?
>  
> Thanks for your help!
>  
> Susan
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file

[Susan C. <hom...@ya...>]

Hi Gerd,
 
Thanks so much for your prompt response, I appreciate it and will look forward to the
2.3 final release!
 
Regards,
 
Susan

----- Original Message ----
From: Gerd Wagner <bir...@t-...>
To: Susan Cline <hom...@ya...>
Cc: squ...@li...
Sent: Wednesday, July 12, 2006 2:18:38 PM
Subject: Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file


Hi Susan,

at the moment SQuirreL does not offer exactly what you ask for. But it will 
maybe already in the 2.3 final release.

All we can offer now is to export the content of an SQL result table. If your 
tables are small enough to be displayed by SQuirreL you may use this function. 
You need to have version 2.3 rc1. Then just right mouse click a result and 
choose the "export CSV" item.

Gerd

Susan Cline wrote:
> Hi,
>  
> I've looked in the documentation and the archives on a way to do this, but I've either missed it
> or maybe it can not be done - I'm hoping someone can help.
>  
> I'm trying to figure out how to export all of the data in a table to a 'load' file - something that
> has delimeters that are appropriate for import.
>  
> I tried all of the "Copy ..." functions available after selecting all rows and none seem to just
> export the data.
>  
> Is there a command to do this, or do I need to use the SQL window to issue the SQL command
> manually for my specific database (Derby)?
>  
> Thanks for your help!
>  
> Susan
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 



-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file

[Robert M. <rob...@gm...>]

On 7/12/06, Susan Cline <hom...@ya...> wrote:
>
> I'm trying to figure out how to export all of the data in a table to a 'load' file - something that
> has delimeters that are appropriate for import.
>

"delimiters that are appropriate for import" into what and using what
tool?  I could interpret this
to mean import into another SQL database using SQL insert statements
delimited by
semi-colons.  If that were the case, then right-click on a table and
choose "Create Data Script".  If what you are looking for is raw data
(without SQL) then refer to Gerd's response.

Rob

Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file

[Susan C. <hom...@ya...>]

Hi Rob,
 
You're right - I wasn't very clear stating what I wanted... but right now I would be happy with either way,
and the way you suggested will work fine for now.
 
I was thinking about something that did not include the insert statement itself, but was more
of the format of:
 
| row 1 data | row 2 data | 
 
However, the insert statements created the way you suggested will be fine.
 
Thanks very much for your answer!
 
Regards,
 
Susan

----- Original Message ----
From: Robert Manning <rob...@gm...>
To: Susan Cline <hom...@ya...>
Cc: squ...@li...; hom...@pa...
Sent: Wednesday, July 12, 2006 5:24:02 PM
Subject: Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file


On 7/12/06, Susan Cline <hom...@ya...> wrote:
>
> I'm trying to figure out how to export all of the data in a table to a 'load' file - something that
> has delimeters that are appropriate for import.
>

"delimiters that are appropriate for import" into what and using what
tool?  I could interpret this
to mean import into another SQL database using SQL insert statements
delimited by
semi-colons.  If that were the case, then right-click on a table and
choose "Create Data Script".  If what you are looking for is raw data
(without SQL) then refer to Gerd's response.

Rob