Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to do export from Squirrel SQL

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hope this is the right group to ask in.
I have successfully installed and setup against a JavaDB database.
But one thing unclear, and isn't mentioned that thoroughly is
how to go about exporting tables to .csv .xml whatever
I think such a good application should have this feature.
But just couldn't find it.
Thanks
Jack
 
Tim Cooke
Sheriff
Pie
Posts: 3206
142
Clojure IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Given my past dealings with SQuirreL I wouldn't trust it to do anything as demanding as an export. It's just far too flakey.

I would suggest using sqlplus
 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tim Cooke wrote:Given my past dealings with SQuirreL I wouldn't trust it to do anything as demanding as an export. It's just far too flakey.

I would suggest using sqlplus


Okay, let's get that one
Thanks
Jack
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jacky Luk wrote:
Tim Cooke wrote:Given my past dealings with SQuirreL I wouldn't trust it to do anything as demanding as an export. It's just far too flakey.

I would suggest using sqlplus


Okay, let's get that one
Thanks
Jack

SQL*Plus is Oracle-specific. However, Oracle's excellent free SQLDeveloper tool can talk to some other databases via JDBC.
 
Tim Cooke
Sheriff
Pie
Posts: 3206
142
Clojure IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
chris webster wrote:SQL*Plus is Oracle-specific

Good point. I'm fairly new to using SQLDeveloper so can't vouch strongly for it but on the face of things it looks alright. I would still be tempted to go for whatever command line utility comes with your flavour of database.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic