Executing the database schema script
You run the database schema script.
Procedure
To use the SQL script that you created, run the execute-schema Ant
task with these parameters:
- -Dserver.url=<server url>
- -DdatasourceName=<data source name>
- [-Dfile=<SQL file>]
- The name of the file to run, which corresponds to the script that you created. If you do not specify this parameter, the task attempts to run a file named output.sql in the directory that is defined as basedir in the build.xml file.
ant execute-schema -Dfile=my_sql_file.sql