CODEWITHSUNDEEP
sqldatabasescriptingdatabase-agnostic
Robert Gould
Robert Gould

Reputation: 69835

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

Upvotes: 4

Views: 8336

Answers (2)

Fred
Fred

Reputation: 5006

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

Upvotes: 2

Jonathan Barbero
Jonathan Barbero

Reputation: 2554

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.

Upvotes: 3

Related Questions