I have an application, for which I must create an installation script. This installation script must:
1. Drop all database objects which are part of my application (if they exist)
2. Create all database objects which are part of my installation.
I have a .sql file per database object - e.g. 1 file per table, 1 file per view.
Could anyone tell me what the best tool for creating my installation script would be?
The following is a link to an Article on the SQL Ant Wizard: