problem with schemaexport

[Amit KumarS]

hi all,

i am new to ant. plz help.. i am pasting a piece of ant script

<schemaexport
      properties="${hibernate.properties.path}"
      quiet="no"
      text="no"
      drop="no"
      delimiter=";"
      output="${subproject.schema-export.path}">
      <fileset refid="hibernate.files"/>
</schemaexport>  

the values set are like followig

<property name="hibernate.properties.path" value="/hibernate.properties"/>
<property name="subproject.schema-export.path" value="schema-export.sql"/>


the hibernate.properties file contains

#Fri May 14 12:46:15 GMT+05:30 2004
hibernate.connection.username=amitcore
hibernate.connection.password=amitcore
hibernate.dialect=net.sf.hibernate.dialect.OracleDialect
hibernate.connection.url=jdbc\ racle\:thin\:@(description\=(address\=(host\=192.168.4.173)(protocol\=tcp)(port\=1521))(connect_data\=(sid\=oradb)))
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver




now the scenerio...

i figured out the schemaexport tag generates "schema-export.sql" file and then executes this on to databse...

but the prob is that it first deletes the tables created on the database and then creates fresh tables which results in loss of test data..

note: - this schema-export.sql file is autogenerated somehow and it has "drop table" at the begining..

now the question is how can i stop the previous tables from getting deleted if previous tables already exist...


plz help..

Amit