i am using "schemaexport" task from ant to create sql script for MSSQL dialect (MSSQL jdbc). however, it creates the sql script starting with drop commands. Since there is nothing to drop, the tool we are using to run the script is giving an error and not proceeding (osql).
- is there any way not to produce DROP commands
- a little off topic, anybody knows if Osql can ignore this problem and continues running the script. or if there is a better tool for running the script for MSSQL.
i use Hibernate 2.1
my ant task is like this:
Code:
<taskdef name="schemaexport" classpathref="export.schema.classpath"
classname="net.sf.hibernate.tool.hbm2ddl.SchemaExportTask"/>
<schemaexport
quiet="no"
text="no"
drop="no"
delimiter=";"
output="schema-export.sql"
config="/hibernate.cfg.xml">
</schemaexport>