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.
目前我有一个自定义工具，可以从我们的数据模型中生成vanilla-SQL（仅使用标准SQL），为我们的新数据库设置数据库模式和初始数据，并做版本补丁等......这部分都很好和花花公子吧。
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?
然而，针对所有不同的数据库（不同的供应商）运行这些SQL脚本是一件痛苦的事情，所以我一段时间后写了一个快速的小Php脚本为我做了这个，但我想知道是否有更好的解决方案来解决这个问题？
Thanks
谢谢
2 个解决方案
#1
3
I use SQL Developer, it's really cool.
我使用SQL Developer，它真的很酷。
It runs in any plataform (is a Java application), you could connect to any database vendor and it's free.
它可以在任何平台上运行（是一个Java应用程序），您可以连接到任何数据库供应商，它是免费的。
#2
2
I use Squirrel, like SQL Developer it is a java application which is free.
我使用Squirrel，就像SQL Developer一样，它是一个免费的java应用程序。
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.
SQuirreL SQL Client是一个图形化Java程序，它允许您查看JDBC兼容数据库的结构，浏览表中的数据，发出SQL命令。
下载和安装
#1
3
I use SQL Developer, it's really cool.
我使用SQL Developer，它真的很酷。
It runs in any plataform (is a Java application), you could connect to any database vendor and it's free.
它可以在任何平台上运行（是一个Java应用程序），您可以连接到任何数据库供应商，它是免费的。
#2
2
I use Squirrel, like SQL Developer it is a java application which is free.
我使用Squirrel，就像SQL Developer一样，它是一个免费的java应用程序。
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.
SQuirreL SQL Client是一个图形化Java程序，它允许您查看JDBC兼容数据库的结构，浏览表中的数据，发出SQL命令。
下载和安装