What's a good tool to run SQL scripts against any database?

views:

310

answers:

+2 Q:

What's a good tool to run SQL scripts against any database?

Currently I have a custom tool which generates vanilla-SQL (only using standard SQL), from our Data-models that sets up database schemas and initial data for our new databases, and do version patches, etc... This part is all fine and dandy right now.

However running these SQL scripts against all the different databases (different vendors) is a pain, so I wrote up a quick little Php script a while back that does it for me, but I was wondering if there is any better solution to this problem?

Thanks

+2 A:

I use SQL Developer, it's really cool.

It runs in any plataform (is a Java application), you could connect to any database vendor and it's free.

Jonathan Barbero 2008-11-14 03:03:39

Yes I use SQL Developer too, but I though it only supported Oracle and Access... are there plugins or something like that?

Robert Gould 2008-11-14 03:18:45

I think you can connect to ODBC datasources? That would allow you to access almost all databases, and even stuff like Excel sheets and flat files.

Rick 2008-11-14 03:29:33

This is sounding better by the moment, but are there any tutorials?

Robert Gould 2008-11-14 03:37:16

Look http://www.oracle.com/technology/products/database/sql_developer/files/featurelist_1_5.htm#con . You can use it with other DB engine, some ones are not supported, but you can use it too. And here is some documentation http://sqldeveloper.solyp.com/download/index.html .

Jonathan Barbero 2008-11-14 08:20:55

At the bottom of this page you can found some configuration doc http://sqldeveloper.solyp.com/screenshots/index.html . The tool use jdbc drivers to connect.

Jonathan Barbero 2008-11-14 08:23:39

+1 A:

I use Squirrel, like SQL Developer it is a java application which is free.

Description

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands.

Download and Installation

Fred 2008-11-14 09:08:38

ansaurus

tags:

views:

answers:

What's a good tool to run SQL scripts against any database?

related questions