• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to do export from Squirrel SQL

 
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 5555
326
IntelliJ IDE Python Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 2407
36
Scala Python Oracle Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 5555
326
IntelliJ IDE Python Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic