squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] objects filter defaults to 100

[Matthew H. <hi...@po...>]

No, I mean I have to right click on the session name in the pane on  
the left and select "Edit Objects Filter".  This brings up a dialog  
and I have to go to the Object Tree tab and uncheck the "Contents -  
Limit rows" checkbox.  Otherwise I end up not seeing all of the  
contents of the tables while browsing them.  SQuirrel does not seem  
to save this setting as I have to do it whenever I open up a new  
session.
   -M@

On Sep 20, 2006, at 11:09 AM, Steve wrote:

> Hi,
>
> Do you mean limiting the number of rows returned by an select  
> statement?
>
> If so, then do the following...
>
> File -> New Session Properties -> click on the SQL tab -> then set  
> "SQL
> results - Limit rows" to whatever number you want.
>
> HTH
>
> ----- Original Message -----
> From: "Matthew Hixson" <hi...@po...>
> To: <squ...@li...>
> Sent: Wednesday, September 20, 2006 1:55 PM
> Subject: [Squirrel-sql-users] objects filter defaults to 100
>
>
>> Is there a way to save the object filter settings?  I have to change
>> this every time I start a new session.
>>    Thanks,
>>     -M@
>>
>> --------------------------------------------------------------------- 
>> ----
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share
> your
>> opinions on IT & business topics through brief surveys -- and earn  
>> cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>

[Squirrel-sql-users] objects filter defaults to 100

[Matthew H. <hi...@po...>]

Is there a way to save the object filter settings?  I have to change  
this every time I start a new session.
   Thanks,
    -M@

[Squirrel-sql-users] SQuirreL/AWT + xgl/compiz = ?

[Todd B. <cha...@gm...>]

I use SQuirrel SQL a lot. It's a fantastic piece of software. It runs
great on my linux workstation except when I enable xgl. With xgl
enabled, SQuirreL is blank. The window is responsive. For example, I
can click where I think the alias' window is and drag and it'll show
me the outline of the alias' window. Anyone know a workaround?

Screenshot: http://chargedsoftware.com/~charged2885/Screenshot-1.png

Todd

[Squirrel-sql-users] table NOT added to Graph

[ziofanale <f.c...@tr...>]

Hello , 

I'm new to Squirrel .. I've created a table with 1 PK and 1 FK with ref to
another table.
I can't add it to my graph , which contains also other tables . 
I can add all other table but this one . I've tried recreating it . no way.

Any ideas ? 
Thanks in advance

Felice 
-- 
View this message in context: http://www.nabble.com/table-NOT-added-to-Graph-tf2290109.html#a6360583
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

[Squirrel-sql-users] Help (New user)

[Upender R. C. <upe...@ya...>]

Hi Everyone,
   
  I started using squirrel recently (I am using version 2.2 Final) 
   
  When I copy & paste the query results in excel sheet, all nulls are copied as <null>, what can I do to avoid this?.
   
  I appreciate your help in advance.
   
  Thank you,
  Upender.
   

 		
---------------------------------
How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone call rates.

Re: [Squirrel-sql-users] Binding variables

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

On 9/12/06, Ada...@sk... <Ada...@sk...> wrote:
> Hallo,
>
> I was wondering if there's some kind of support for variable binding. Thank to its plugins, Squirrel makes a great pet. But i have hard time debuging query with parameters from my java source (e.g. select * from customers where id = ? and age > ? and ... and blahBlah > ? ). I can not bind variables like in other db tools.
>
> There's a workaround, but manual rewrite of all parameters to actual value is tidious work and it tends to be source of errors -- when one forgot to replace actual parameter back to question mark when finished.
>
> How do you execute such queries? Do you konw some 'handy' plugin for binding?

Adam,

You are right, that is pretty annoying.  I can recall replacing the
"?" placeholders with
actual values by hand just recently.  Indeed, it would be a nice
enhancement to scan
the SQL statement as it is being executed and if it has bind vars,
prompt for the value.
Would probably need to consult the metadata if the SQL didn't include
the list of
columns (for insert statements with many columns it would be confusing to know
which is which).  But it's certainly doable.  Why don't you submit a
feature request for
this and I'll look at it for the 2.4 release.

Rob

Re: [Squirrel-sql-users] SQL 7.0 compatability

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

krishna wrote:
> ok. Thanks for your response. One basic question. Will Squirrel SQL works on
> SQL SERVER 7.0?
It's quite some time ago that I used it on SQL SERVER 7.0. At this time it 
worked fine. I can't see no reason why it shouldn't if you use a suiting driver.

Gerd

Re: [Squirrel-sql-users] SQL 7.0 compatability

[krishna <kri...@gm...>]

ok. Thanks for your response. One basic question. Will Squirrel SQL works on
SQL SERVER 7.0?

Thanks
KRishina

manningr wrote:
> 
> On 9/13/06, krishna <kri...@gm...> wrote:
>>
>> Hi
>> I am using Squirrle SQL Ver 2.2 final. Can I connect to SQL 7.0 using
>> this?
>> I can able to connect to my  SQL server 2000. But when I tried to connect
>> to
>> my SQL 7.0 server I am getting an error message "The TDS prelogin
>> response
>> is incomplete. The target server must be SQL Servr 2000 or later." - Can
>> anybody clarify on this?
>>
> 
> I'll guess that the driver you are using (which works fine for
> SQLServer 2000) isn't
> compatible with version 7.0 (what's that like 98 or something :)  My
> guess would
> be that you need an earlier version of the JDBC driver to connect to
> version 7.0
> based on my limited knowledge of MS SQLServer.
> 
> Rob
> 
> -------------------------------------------------------------------------
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/SQL-7.0-compatability-tf2262898.html#a6299801
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] SQL 7.0 compatability

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

On 9/13/06, krishna <kri...@gm...> wrote:
>
> Hi
> I am using Squirrle SQL Ver 2.2 final. Can I connect to SQL 7.0 using this?
> I can able to connect to my  SQL server 2000. But when I tried to connect to
> my SQL 7.0 server I am getting an error message "The TDS prelogin response
> is incomplete. The target server must be SQL Servr 2000 or later." - Can
> anybody clarify on this?
>

I'll guess that the driver you are using (which works fine for
SQLServer 2000) isn't
compatible with version 7.0 (what's that like 98 or something :)  My
guess would
be that you need an earlier version of the JDBC driver to connect to version 7.0
based on my limited knowledge of MS SQLServer.

Rob

[Squirrel-sql-users] SQL 7.0 compatability

[krishna <kri...@gm...>]

Hi 
I am using Squirrle SQL Ver 2.2 final. Can I connect to SQL 7.0 using this?
I can able to connect to my  SQL server 2000. But when I tried to connect to
my SQL 7.0 server I am getting an error message "The TDS prelogin response
is incomplete. The target server must be SQL Servr 2000 or later." - Can
anybody clarify on this?

Thanks
Krishna
-- 
View this message in context: http://www.nabble.com/SQL-7.0-compatability-tf2262898.html#a6278782
Sent from the squirrel-sql-users forum at Nabble.com.

[Squirrel-sql-users] Binding variables

[<Ada...@sk...>]

Hallo,=20

I was wondering if there's some kind of support for variable binding. =
Thank to its plugins, Squirrel makes a great pet. But i have hard time =
debuging query with parameters from my java source (e.g. select * from =
customers where id =3D ? and age > ? and ... and blahBlah > ? ). I can =
not bind variables like in other db tools.

There's a workaround, but manual rewrite of all parameters to actual =
value is tidious work and it tends to be source of errors -- when one =
forgot to replace actual parameter back to question mark when finished.

How do you execute such queries? Do you konw some 'handy' plugin for =
binding?

Yours sincerely

Adam Skalny

Re: [Squirrel-sql-users] Cant connect SQL

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

On 9/7/06, krishna <kri...@gm...> wrote:
>
> Hi
> The the JDBC URL that you  I am  using is
> jdbc:microsoft:<aliasname>:\\<SQL-server-name>\<database-name>
>
> Driver class name is - microsft NS sql server jdbc driver

I don't recognize that driver class name.  In the SQL-Server 2005 version
of the JDBC driver it looks like:

com.microsoft.sqlserver.jdbc.SQLServerDriver

The URL look for the SQL-Server 2005 version of the JDBC driver looks like:

jdbc:sqlserver://<SERVER>:<PORT>/database=<DATABASE_NAME>

At the very least, I believe your backslashes ("\") should be forward
slashes ("/")

You probably want to go and get the latest SQL-Server 2005 version of the
JDBC driver from Microsoft.  It seemed compatible with SQL-Server 2000
when I had tested it in the past.

Rob

Re: [Squirrel-sql-users] Cant connect SQL

[krishna <kri...@gm...>]

Hi 
The the JDBC URL that you  I am  using is 
jdbc:microsoft:<aliasname>:\\<SQL-server-name>\<database-name>

Driver class name is - microsft NS sql server jdbc driver

Thanks
Krishina


manningr wrote:
> 
> On 9/6/06, krishna <kri...@gm...> wrote:
>>
>> Hi
>> I am trying to connect Squirrle SQL client 2.2 with the server MS sql
>> 7.0. I
>> am getting an error message saying unable to connect. check your url". I
>> have tried with different options. Can you help me what could be the
>> problem?
> 
> Can you give us the JDBC URL that you are using, along with the driver
> class name? (This will help us to tell you what the problem is)
> 
> Rob
> 
> -------------------------------------------------------------------------
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/Cant-connect-SQL-tf2225264.html#a6184275
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] Cant connect SQL

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

On 9/6/06, krishna <kri...@gm...> wrote:
>
> Hi
> I am trying to connect Squirrle SQL client 2.2 with the server MS sql 7.0. I
> am getting an error message saying unable to connect. check your url". I
> have tried with different options. Can you help me what could be the
> problem?

Can you give us the JDBC URL that you are using, along with the driver
class name? (This will help us to tell you what the problem is)

Rob

[Squirrel-sql-users] Cant connect SQL

[krishna <kri...@gm...>]

Hi 
I am trying to connect Squirrle SQL client 2.2 with the server MS sql 7.0. I
am getting an error message saying unable to connect. check your url". I
have tried with different options. Can you help me what could be the
problem? 
Thanks
Krishna
-- 
View this message in context: http://www.nabble.com/Cant-connect-SQL-tf2225264.html#a6166363
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] can't connect to MS SQL Server

[krishna <kri...@gm...>]

I am using sql 7.0. I have tried with all the options by connection squirrel
sql client with MS sql server. But it is giving the error message unable to
connect chek url. Can you guide me where was the problem.

Advanced thanks
Krishna

Matthew Dahlman wrote:
> 
> Hi Ranier,
>  
> In case you are still working on this problem...
> "TCP/IP connection could not be established" generally happens when the
> client can't connect to the database server at all. The reasons are
> usually
> things like these:
> - The server isn't running
> - The server is listening on a different port
> - With SQL Server, TCP/IP access isn't always activated
> - A firewall is blocking your access
>  
> Your problem may be different, but it's likely to be similar to something
> like this.
>  
> I troubleshoot this sort of error like this:
> 1. Confirm that ping mobil-cor works.
> 2. Confirm that telnet mobil-cor 1433 works.
>  
> Good luck.
>  
> Regards,
> Matt
> 
>   _____  
> 
> From: Rainer F. Cornely [mailto:Co...@ls...] 
> Sent: Thursday, May 11, 2006 17:18 PM
> To: Matthew Dahlman; David Cook; squ...@li...
> Subject: AW: [Squirrel-sql-users] can't connect to MS SQL Server
> 
> 
> 
> Hi,  thanks for Your reply.
> 
>  
> 
> If I use the URL without the "microsoft." Then I get another error :
> 
> test: Es konnte keine TCP/IP-Verbindung zu Host "" hergestellt werden
> 
> (Translation: TCP/IP connection could not be established to Host "")
> 
> . java.net.ConnectException: Connection refused: connect
> 
> This Error message  is thrown even with the URL: jdbc:sqlserver://
> 
> That means for me it seems to be a version problem not a URL problem
> 
> Regards
> 
> Rainer
> 
>  
> 
>  
> 
>  
> 
>   _____  
> 
> Von: Matthew Dahlman [mailto:mda...@su...] 
> Gesendet: Donnerstag, 11. Mai 2006 03:27
> An: 'David Cook'; Rainer F. Cornely;
> squ...@li...
> Betreff: RE: [Squirrel-sql-users] can't connect to MS SQL Server
> 
>  
> 
> Hi Rainer,
> 
>  
> 
> Dave is correct.
> 
>  
> 
> To add a little explanation: the url that you used is correct for the MS
> SQL
> Server 2000 driver, but it won't work for the 2005 driver.
> 
>  
> 
> By the way, property names like 'databaseName' are case insenstive--no
> problems there. But it's standard practice to follow the suggested format
> (databaseName, lastUpdateCount, etc.).
> 
>  
> 
> Regards,
> 
> Matt
> 
>  
> 
>   _____  
> 
> From: squ...@li...
> [mailto:squ...@li...] On Behalf Of David
> Cook
> Sent: Wednesday, May 10, 2006 21:31 PM
> To: 'Rainer F. Cornely'; squ...@li...
> Subject: RE: [Squirrel-sql-users] can't connect to MS SQL Server
> 
> Rainer -
> 
>  
> 
>     Hmm...that looks like the same driver's JAR name that I use.  So,
> here;s
> 
> some differences I noticed between your URL and what my working URL looks
> like:
> 
>  
> 
> You used:     jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz
> 
>  
> 
> Try taking the 'microsoft' part out of your URL 'prefix'...e.g.
> 
>       jdbc:sqlserver://mobil-cor:1433;databaseName=xyz
> 
>  
> 
> Also, I notice I use a CAPITAL N in 'databaseName'...don't know whether
> that
> 
> key is case-sensitive.
> 
>  
> 
> (I don't know anything about 'Extra' classpath vsjust classpath, so I
> can't
> speak
> 
> to how you have that part set up.)
> 
>  
> 
> Hope this helps...
> 
>  
> 
>         Dave
> 
> -----Original Message-----
> From: squ...@li...
> [mailto:squ...@li...]On Behalf Of Rainer
> F. Cornely
> Sent: Wednesday, May 10, 2006 6:07 AM
> To: squ...@li...
> Subject: [Squirrel-sql-users] can't connect to MS SQL Server
> 
>  
> 
> Hi to all.
> 
> I'm new to SquirreL which is the best tool I've seen.
> 
>  
> 
> Everything is fine with all features including the plugins while connected
> to Oracle 10g.
> 
>  
> 
> But I can't make it to get a connection to MS SQL
> 
>  
> 
> The System is XP Pro
> 
> Squirrel is 2.2 final
> 
>  
> 
> The Settings are:
> 
>  
> 
> Class Path: com.microsoft.sqlserver.jdbc.SQLServerDriver
> 
> Extra Class Path: .....\Microsoft SQL Server 2005 JDBC
> Driver\sqljdbc_1.0\enu\sqljdbc.jar
> 
>  
> 
> Release Information
> 
> Microsoft SQL Server 2005 JDBC Driver
> 
> Version 1.0
> 
> January 2006
> 
>  
> 
> The database is up and running.
> 
>  
> 
> The URL's used: jdbc:microsoft:sqlserver://mobil-cor:1433
> 
>  
> jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz
> 
>  
> 
> The Error Message: Test: Unable to create connection. Check your URL.
> 
>  
> 
> Can somebody help me?
> 
> Thanks in advance
> 
>  
> 
> Rainer
> 
>  
> 
>  
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/can%27t-connect-to--MS-SQL-Server-tf1590611.html#a6166041
Sent from the squirrel-sql-users forum at Nabble.com.

[Squirrel-sql-users] not listing all tables

[Matthew H. <hi...@po...>]

I am using 2.3rc1 to connect to a SQL Server 2000 database.  I was  
using the SQL Server 2000 JDBC driver, but Squirrel was telling me  
that it was not JDBC 3.0 compliant.  I found the SQL Server 2005 JDBC  
driver, which is JDBC 3.0 compliant and is said to work with SQL  
Server 2000 databases.  Squirrel no longer complains about this  
driver, but using both of them I do not see a complete list of table  
names.  It is listing 127 tables out of a total of 147.  They are  
listed alphabetically.
   Any idea why the list is getting truncated?
   Thanks,
    -M@

Re: [Squirrel-sql-users] 2.3 rc1 throwing exceptions on JDK 1.6 beta2

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

On 8/29/06, Raghu <rag...@co...> wrote:
> Hello,
>
> I believe I have read something regarding incompatibility between
> Squirrel and Java 1.6 before, if so, what is the issue? I am getting
> Any pointers on how to get around this will be much appreciated.
>
> TIA
Take a look at the following bug report:

http://sourceforge.net/tracker/index.php?func=detail&aid=1448738&group_id=28383&atid=393414

Rob

[Squirrel-sql-users] 2.3 rc1 throwing exceptions on JDK 1.6 beta2

[Raghu <rag...@co...>]

Hello,

I believe I have read something regarding incompatibility between 
Squirrel and Java 1.6 before, if so, what is the issue? I am getting 
this exception when making a connection to mysql.

java.lang.RuntimeException: java.lang.ClassNotFoundException: 
[Lnet.sourceforge.squirrel_sql.client.gui.db.SQLAliasSchemaDetailProperties;
    at 
net.sourceforge.squirrel_sql.fw.util.Utilities.cloneObject(Utilities.java:351)
    at 
net.sourceforge.squirrel_sql.client.gui.db.SQLAlias.assignFrom(SQLAlias.java:150)
    at 
net.sourceforge.squirrel_sql.client.session.Session.<init>(Session.java:195)
    at 
net.sourceforge.squirrel_sql.client.session.SessionManager.createSession(SessionManager.java:135)
    at 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.createSession(ConnectToAliasCommand.java:349)
    at 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:313)
    at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: 
[Lnet.sourceforge.squirrel_sql.client.gui.db.SQLAliasSchemaDetailProperties;
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at 
net.sourceforge.squirrel_sql.fw.util.Utilities$1.resolveClass(Utilities.java:340)
    at java.io.ObjectInputStream.readNonProxyDesc(Unknown Source)
    at java.io.ObjectInputStream.readClassDesc(Unknown Source)
    at java.io.ObjectInputStream.readArray(Unknown Source)
    at java.io.ObjectInputStream.readObject0(Unknown Source)
    at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
    at java.io.ObjectInputStream.readSerialData(Unknown Source)
    at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
    at java.io.ObjectInputStream.readObject0(Unknown Source)
    at java.io.ObjectInputStream.readObject(Unknown Source)
    at 
net.sourceforge.squirrel_sql.fw.util.Utilities.cloneObject(Utilities.java:344)
    ... 7 more


Any pointers on how to get around this will be much appreciated.

TIA

Raghu

Re: [Squirrel-sql-users] looking for graph plugin

[Matthew H. <hi...@po...>]

Got it.  Thanks.
  -M@

On Aug 28, 2006, at 1:05 PM, Robert Manning wrote:

> On 8/28/06, Matthew Hixson <hi...@po...> wrote:
>> The plugin page currently links all of the plugins back to the same
>> page.
>>
>> http://squirrel-sql.sourceforge.net/index.php?
>> page=plugins#installationDownload
>>
>> Could someone tell me where I can get the graph plugin for 2.3rc1?
>
> The plugins all come bundled in the installer now.  If you  
> installed from
> plain zip archive, then you would want the "optional" plain zip  
> archive
> which has all optional plugins (graph plugin is optional in the  
> installer)
>
> Rob
>

Re: [Squirrel-sql-users] looking for graph plugin

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

On 8/28/06, Matthew Hixson <hi...@po...> wrote:
> The plugin page currently links all of the plugins back to the same
> page.
>
> http://squirrel-sql.sourceforge.net/index.php?
> page=plugins#installationDownload
>
> Could someone tell me where I can get the graph plugin for 2.3rc1?

The plugins all come bundled in the installer now.  If you installed from
plain zip archive, then you would want the "optional" plain zip archive
which has all optional plugins (graph plugin is optional in the installer)

Rob

[Squirrel-sql-users] looking for graph plugin

[Matthew H. <hi...@po...>]

The plugin page currently links all of the plugins back to the same  
page.

http://squirrel-sql.sourceforge.net/index.php? 
page=plugins#installationDownload

Could someone tell me where I can get the graph plugin for 2.3rc1?
  Thanks,
    -M@

Re: [Squirrel-sql-users] Exporting table data between Databases

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

On 8/24/06, Steven Rose <ucf...@gm...> wrote:
> Is there any way to create table scripts and data scripts  for a specific
> Database. For example if i am in a  Oracle  Database and want to generate a
> Script to  create a table in my  Oracle database in  my  mysql Database. I
> know there is  a way to graphically do this using  DB Copy Plugin  but  I
> need to do this using a script. Is this possible or is this a feature
> request. Thanks.
>

Hi Steve,

DB Copy plugin can be configured to write a script file containing a rough
approximation of the copy operation that was performed.  The script gets
placed in <user.home>/.squirrel-sql/plugins/dbcopy/scripts and is called
<source>_to_<destination>.sql.  I say it's a rough approximation because
insert records with binary columns (BLOB, VARBINARY, LONGVARBINARY,
etc.) from scripts isn't well supported by most databases.  So it currently
creates the "create" statements, but doesn't include the insert statements
for tables with binary columns.  This plugin gets help from hibernate to
translate the columns correctly from one database dialect to another.

However, there is another way to accomplish what you are asking which is
quicker and might work ok for Oracle -> MySQL.  You can open
a session to Oracle, right click on the table and choose "create table script".
That puts the table create statement in the SQL tab.  Next, right-click on
the table and choose "create data script".  This will place an insert statement
into the SQL tab for every record in that table.  This is limited to one table
at a time, so it may be tedious if you have a large number of tables to copy.
The biggest drawback to this approach is that it produces SQL create
statements that may only work on the database type that it was created from.
For instance, if you have a NUMBER column in Oracle, the script will have
NUMBER column types which aren't valid SQL types in MySQL.  This is
one of the reasons that I wrote the DBCopy plugin.

Rob

[Squirrel-sql-users] Exporting table data between Databases

[Steven R. <ucf...@gm...>]

Is there any way to create table scripts and data scripts  for a specific
Database. For example if i am in a  Oracle  Database and want to generate a
Script to  create a table in my  Oracle database in  my  mysql Database. I
know there is  a way to graphically do this using  DB Copy Plugin  but  I
need to do this using a script. Is this possible or is this a feature
request. Thanks.

[Squirrel-sql-users] web interface?

[Rusty W. <ru...@be...>]

Is there anything that's as nice as Squirrel but is a web application? 
Running a standalone x windows gui application doesn't really work for me.

Thanks