Search code examples
.netsqlversion-controlddl

Best database independent SQL DDL utility?

I'm working on a project for the .net platform and would like to support multiple database types. I would like to keep the DDL under source control in a generic format then convert it to database specific DDL for deployment.

So I'm looking for utilities that will convert generic DDL into database specific DDL. Ideally it would support MSSQL 05/08, MySQL, Oracle, Postgres, & DB2 out of the box.

Here are the tools that I've found so far:

  1. XML to DDL
    • No built in support for MSSQL.
  2. DdlUtils
    • No command line utility. Must be called from java or ant scripts.
  3. ActiveRecord::Migration
    • No support for foreign keys
    • Not sure how to integrate with .net project.

Does anyone have experience with those I've mentioned or know of others?

Solution

  • The only one that I know of that has support for SQL Server is SQLFairy. It's written in Perl and is pretty feature rich. XML2DDL is pretty good too, but if it doesn't support your DBMS of choice it's not really viable.