generate sql script from tables

squirrel-sql
cometta picture cometta · Jun 30, 2009 · Viewed 32.3k times · Source

alt text http://www.freeimagehosting.net/uploads/64fac9c8c4.gif

is it possible to generate sql scripts from for all tables ? i want to generate the sql script and import into another database server

Answer

luarwo picture luarwo · Mar 31, 2010

Select the tables you want to export, right click, scripts>create table script. It works in mysql, not sure about oracle.

Related questions

how to connect to SQL Server with SQuirreL SQL from non domain registered Linux box?

I need to connect to a SQL 2008 R2 Server from my Linux box that's not registered in my company's domain. I'm trying to use SQuirreL SQL version 3.2.1. I downloaded Microsoft SQL Server JDBC Driver 3.0 and assigned it to SQuirreL on …

Read More
Username & Password in JDBC Connection URL

I was using a SQuirrel SQL Client to connect & browse my oracle database servers. I have given the credentials in the connection URL itself. But it still prompts for the username and password. Does it really required to provide …

Read More
How can I call a DB2 stored procedure with OUT parameters from SQuirreL SQL?

I really like SQuirreL SQL as a SQL query tool, but I've never been able to get it to call stored procedures in our AS/400 DB2 database. I always get the error "The number of parameter values set or registered …

Read More