How to generate DDL script for domain classes in Grails using schema-export target

Posted by Deepak Mittal

On most of my grails projects, I am used to let grails handle database schema creation for me. However, there is a project where the database is shared between multiple applications. In that project, we have to check-in our table creation/modification script as a SQL file, which is later executed by a DBA.

I use a not-so-commonly known Grails command/script schema-export to help me deal me with this situation without much fuss of writing the DDL script myself.

To generate DDL script for all the domain classes

> grails schema-export

The DDL script in this case is created as {PROJECT_ROOT}/target/ddl.sql file.

You can also specify the path of the file where you want the schema file to get generated.

> grails schema-export sql/ddl.sql

Hope this helps!

-Deepak

This entry was posted on July 15th, 2010 at 12:54 am and is filed under Database, Grails . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

5 Responses to “How to generate DDL script for domain classes in Grails using schema-export target”

Jay Chandran says:

September 21, 2010 at 10:16 am

Thanks for that. Never knew it before!
coupon says:

June 5, 2011 at 9:39 am

Important?…

Is this really updated?…
1 Hour Cash Loans says:

October 8, 2011 at 8:08 pm

One Hr Cash Loans…

[...]How to generate DDL script for domain classes in Grails using schema-export target « Intelligrape Groovy & Grails Blogs[...]…
leak says:

November 29, 2011 at 11:24 am

leak…

[...]How to generate DDL script for domain classes in Grails using schema-export target « Intelligrape Groovy & Grails Blogs[...]…
vouchers says:

December 13, 2011 at 5:37 pm

vouchers…

[...]How to generate DDL script for domain classes in Grails using schema-export target « Intelligrape Groovy & Grails Blogs[...]…