Search code examples
sqldatabasescriptingdatabase-agnostic

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


Solution

  • 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.