Command line utility to generate schema

nbhatia · **Joined:** Sun Sep 25, 2005 11:35 pm **Posts:** 57

Is there a command line utility to generate schemas. I know there is the SchemaExport class, but that requires writing a program.

KPixel · **Posted:** Mon Oct 24, 2005 10:06 am

The program to write is very straighforward; so you can do your own one...

nbhatia · **Joined:** Sun Sep 25, 2005 11:35 pm **Posts:** 57

I am not very savvy with loading assemblies and stuff, so this is the best I could do:

Code:

            Configuration config = new Configuration();
            config.Configure(
                System.Configuration.ConfigurationManager.AppSettings["nhibernate.config"]);
            NHibernate.Tool.hbm2ddl.SchemaExport schemaExport =
                new NHibernate.Tool.hbm2ddl.SchemaExport(config);
            schemaExport.Create(true, false);

However this approach required the assembly to be included with my program and thus the program is specific to this assembly. I was looking to find or write something more generic that could load any config file and assembly at runtime. Any pointer in the right direction would be much appreciated. Thanks.

KPixel · **Posted:** Tue Oct 25, 2005 11:12 am

You can create a console/windows application that take as parameter the path to the xml file containing the configuration settings of NHibernate...